| Subject | Date Asked | Expert |
|
| Procedure | 7/7/2008 | Suchitra Joshi |
Q: I just faced a question from oracle corp that Whenever a procedure is called inside a package ...
A: The main reason is that the stored procedures/packages are loaded once into the SGA and remain there ...
|
| import data from .dmp file | 7/5/2008 | Elliot Mak |
Q: I have a vdata.dmp file created in oracle 9.0.1.1.1. I do not know any user,password and any ...
A: Good day Munna Here is what I will do in this situation 1. Write the DDL from DMP file 2. Examine ...
|
| oracle download | 7/4/2008 | Elliot Mak |
Q: could you please guide me on how to download oracle 10g and oracle 11g from their download ...
A: Good day ddy, There are only two ways to obtain Oracle binaries, they are 1. Through ...
|
| Recovery with RMAN | 7/4/2008 | Elliot Mak |
Q: I'm doing a recovery of a database with RMAN but I've a problem: When I recovery until time1, I've ...
A: I have never done this before, but from what I understand about RMAN configuration, you can ...
|
| Performance of a Stored Procedure | 7/3/2008 | Suchitra Joshi |
Q: How to check the performance of a stored procedure. and how to check the performance of a query? ...
A: 1) You can check performance of the stored procedure by either of the 2 ways - - SQL_TRACE and ...
|
| Index | 7/3/2008 | Suchitra Joshi |
Q: 1>How to check a query is utilizing a particular index. 2>If a table consists of 2 or 3 indexes ...
A: 1) You can check the query execution using EXPLAIN PLAN. More info at following site - ...
|
| Oracle IMP utility | 7/2/2008 | Elliot Mak |
Q: I have created two databases in oracle on the same PC. Now If I run IMP command how can I select a ...
A: Good day Pankaj In order for you to perform the import, you will have to set the ORACLE_SID ...
|
| SQL Loader | 7/2/2008 | Suchitra Joshi |
Q: I need to create a .CTL file for a given table and in the data file the columns are scattered here ...
A: The Filler option is used only when there is a column in the table, but no corresponding column in ...
|
| important | 7/2/2008 | Elliot Mak |
Q: Error coming as Ora600 while import the dmp file. help me in resolving the issue.
A: Sorry for the previous message. It was responding to another issue. By have put this in yours by ...
|
| describe all tables in database | 7/1/2008 | Edson |
Q: i am thivya. i want to know whether is there any privilege to describe all the tables in my datbase ...
A: There is not a thing such that. What you can do is to make a script: SET HEAD OFF SPOOL ...
|
| profile in unix | 6/30/2008 | Suchitra Joshi |
Q: We can see database entry by using oratab and profile command..what is difference between oratab and ...
A: Oratab ------- "oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when ...
|
| Profile | 6/30/2008 | Edson |
Q: We can see database entry by using oratab command and profile command..what is difference between ...
A: "oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when installing ...
|
| ORA-12545 connect failed target host or object does not exist | 6/27/2008 | Elliot Mak |
Q: we are doing a project in VB with oracle8i as back end. when i try to run the command "tnsping ...
A: Sorry for the late reply. I just got access to internet just now. To answer your questions. It ...
|
| Oracle8i- TNS could not resolve service name | 6/26/2008 | Edson |
Q: i am thivya working as a software developer. we got a project with VB as front end and oracle8i ...
A: It can be many things, but there are some more possible: 1) The file TNSNAMES contains the ...
|
| Oracle8i- TNS could not resolve service name | 6/26/2008 | Peter Choi |
Q: i am thivya working as a software developer. we got a project with VB as front end and oracle8i ...
A: An ORA-12154 covers a lot of possible errors. For starters, can you connect to the database using ...
|
| output statement | 6/25/2008 | Elliot Mak |
Q: can i print my output in pl/sql in a single line please write statement for this ANSWER: Good day, ...
A: In order for you to write a program like this, the program will need to: - know how many rows it ...
|
| How to move database from Microsoft SQL Server 2005 to Oracle 9i? | 6/25/2008 | Peter Choi |
Q: I have a question regarding moving from another platform to Oracle 9i platform. Is there a tool ...
A: Oracle does have a migration path for SQL Server to Oracle 10g and 11g (although it's similar for ...
|
| oracle | 6/24/2008 | Peter Choi |
Q: i just passed the OCP exam, can i get the entry level job or internship in USA.
A: Congratulations on passing your OCP exam. You can certainly apply for position in your local market ...
|
| output statement | 6/21/2008 | Elliot Mak |
Q: can i print my output in pl/sql in a single line please write statement for this
A: Good day, You can print your PL/SQL output in a single line using concatenation. Here is an ...
|
| export security | 6/21/2008 | Peter Choi |
Q: If i have dump file from other schema i can easily create newuser and write imp newuser/password ...
A: I was referring to the Oracle ROLES (DBA_ROLES, USER_ROLES) that are associated and granted to ...
|
| Cluster Index and Non Cluster Index | 6/19/2008 | Suchitra Joshi |
Q: Mam what is the difference between clustered Index and Non Clustered Index.Do they come under ...
A: I am not sure I can explain this in detail, but you will get more information on indexes at the ...
|
| Call a Function inside sql | 6/19/2008 | Suchitra Joshi |
Q: How to call a function inside a sql statement whereas we cannot call a procedure. please give me a ...
A: Here is the sample code to call a function from SQL (Assuming you have table project having columns ...
|
| export security | 6/18/2008 | Peter Choi |
Q: If i have dump file from other schema i can easily create newuser and write imp newuser/password ...
A: Oracle assumes the individual taking the backup will be responsible for securing the dump file. ...
|
| DML statement with Dynamic Query or Execute Immediate | 6/17/2008 | Suchitra Joshi |
Q: Can I use Select or DML statements with Dynamic Query or Execute Immediate Statement. Scenario I ...
A: Dynamic query is mainly used when we do not know the tablenames or where conditions in advance. So ...
|
| Oracle commands from Windows command line... | 6/16/2008 | Peter Choi |
Q: Peter, a couple of years ago you asked the"Is there a way to run oracle commands *directly* from the ...
A: With Oracle 8i and higher, you can now invoke SQL*PLUS from a MS-DOS command line in Windows. The ...
|
| Oracle - list databases | 6/16/2008 | Suchitra Joshi |
Q: What command line do you use to list the databases and tables in an oracle instance and also ...
A: To view database, instances, tables and columns, you have to use different queries as follows ...
|
| Oracle exp and import | 6/13/2008 | Peter Choi |
Q: I have 2 questions : 1.I want to export and than import specific sequences ( only some of the ...
A: Here's an answer from Ari Kaplan, one of many Oracle gurus: When exporting on the TABLE level, ...
|
| Oracle 9i to 10g upgrade | 6/12/2008 | Elliot Mak |
Q: .We are planning to upgrade Oracle from 9i to 10g.We are currently using Weblogic Application ...
A: Good day Naresh In order to upgrade Oracle from 9i to 10g Release 2, there are a lot of planning ...
|
| Calling SQL Stored procedure from PLSQL function | 6/11/2008 | Suchitra Joshi |
Q: As a follow-up, I could not reply back to the previous thread. The only option that successfully ...
A: In that case, I would suggest you write the procedure/function tempsqlsp in oracle instead of sql ...
|
| Calling SQL Stored procedure from PLSQL function | 6/11/2008 | Suchitra Joshi |
Q: I have created a simple PLSQL function to return a value that is pulled back from SQL server. ...
A: Remove the RNPS level from the pragma and check whether it compiles. Following is the explanation ...
|
| Calling SQL Stored procedure from PLSQL function | 6/11/2008 | Suchitra Joshi |
Q: I have created a simple PLSQL function to return a value that is pulled back from SQL server. ...
A: I am not quite sure of this. But you can try writing a packaged function as follows - CREATE OR ...
|
| union syntax | 6/11/2008 | Suchitra Joshi |
Q: how to fetch fields from three tables in a single statement The Query(select ...
A: The error indicates that there are some duplicate column names in some of the 3 tables. For eg. ...
|
| creating a CSV file from oracle 10g database | 6/9/2008 | Elliot Mak |
Q: I am using oracle 10g with unix server,what i need is to export the database into a CSV file and ...
A: It looks like the Oracle cannot access the directory specified due to the following: 1. Oracle does ...
|
| question related to import .dmp file | 6/6/2008 | Peter Choi |
Q: .. I recently installed oracle9i in to my system.and I am having one .dmp file.I want to import .dmp ...
A: 1. Can you connect to your database using SQL*Plus? If yes, then 2. The syntax for the command-line ...
|
| ORA-22905 | 6/5/2008 | Peter Choi |
Q: I'm trying to install the Oracle Warehouse Builder but when I'm configuring the Repository, appear ...
A: http://www.orafaq.com/forum/t/70983/0/ It may be possible that the version of OWH that you are ...
|
| pl/sql | 6/4/2008 | Suchitra Joshi |
Q: what are the types of procedures? what is the difference between stored procedures& stand-alone ...
A: As you pointed out, there are only two types of procedures - stored and stand alone. Stored ...
|
| dba questions | 6/3/2008 | Peter Choi |
Q: Can one load data into multiple tables at once? What tuning indicators can one use? . What should ...
A: 1. Generally, Oracle DBA perfer to load tables one at a time. While it is possible to load multiple ...
|
| some dba questions | 6/3/2008 | Elliot Mak |
Q: How does one use the import/export utilities? Can one resize tablespaces and data files? Can one ...
A: Good day Shanthi I assume that you are using Oracle 10g R2 or above. Question #1: How does one ...
|
| creating a CSV file from oracle 10g database | 6/3/2008 | Elliot Mak |
Q: I am using oracle 10g with unix server,what i need is to export the database into a CSV file and ...
A: Good day, Tom Kyte has provided a very good example in how to perform the extract using PL/SQL that ...
|
| insert with select command | 6/2/2008 | King |
Q: I have a problem with insert statement with select. I have two tables named tbl1 and tbl2 with 5 ...
A: Here is the solution: INSERT INTO tbl_temp2 ...
|
