Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Datapump & export/import?
- 2 Answers
- 12085 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
how can you schedule a job in database?
how can you find out if a table can be redefined?
What is fill factor? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is grd?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are statistics, under what circumstances they go out of date, how do you update them?
what do you understand by fine-grained auditing?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How can you control the amount of free space in your index pages? : sql server DBA
who owns the operating system files created by the utl_file package?
What is dcl? : sql server DBA
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
how does an oracle clusterware manage crs resources?
