What is the difference between Datapump & export/import?
- 2 Answers
- 11020 Views
- I also Faced
- E-Mail Answers
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
What are the operating modes in which database mirroring runs? : sql server DBA
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?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what is the diffrence between core dba and apps dba?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to start SQL Server in minimal configuration mode?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what do you understand by fine-grained auditing?
how can you get actual data change values from previous transactions in oracle?
how can you implement fine-grained auditing?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
