Answer / mohapatra.gouranga@gmail.com

You should implement parallelisim
e.g.,
expdp full=y directory=data_pump dumpfile=dumpfile%U.dmp
logfile=logfile_exp.log parallel=5 filesize=10G
exclude=statistics

Explain CREATE DATABASE syntax?

2 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

What command would you use to create a backup control file?

2 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

What does coalescing a tablespace do?

1 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

how can you schedule a job in database?

0 Answers   Oracle,

---

What type of index should you use on a fact table?

1 Answers  

---