What is the difference between Datapump & export/import?
Answer Posted / kittu_chintu2005
Export/Import: traditional backup of oracle database, we can't resume the export/import job if we stop the job in middle. We can't attach any job to running job @ exp/imp. We need not to create a file structure @ oracle level
Datapump: It's introduced from 10g. We can resume the datapump job if we stop the job in middle. We can attach a datapump job to running job. We need create file structure @ oracle level and OS level.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is fill factor? : sql server DBA
what is a user-defined lock?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is logical system in sap basis
internal architecture
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Why would you call update statistics? : sql server DBA
what are the differences of where and if in SAS?
How can you control the amount of free space in your index pages? : sql server DBA
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
what is grd?
what is the diffrence between core dba and apps dba?
What would you do with an "in-doubt" distributed transaction?
how can you find out if a table can be redefined?