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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is the use of recording information about current session?
What is the default port no on which sql server listens? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
when does an alert gets signaled?
How would you extract DDL of a table without using a GUI tool?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is a user-defined lock?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is dbcc? : sql server DBA
What are the commands used in dcl? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
what are the performance views in an oracle rac environment?