What is the difference between Datapump & export/import?

2 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

Can you redefine a table online?

0 Answers   Oracle,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

what is the use of home directory???

1 Answers   HP,

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---