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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
who owns the operating system files created by the utl_file package?
What is the difference between clustered and non-clustered index? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How would you extract DDL of a table without using a GUI tool?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what is a user-defined lock?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Can you redefine a table online?
how can you process messages in order asynchronously?