why Datapump is faster than traditional export and import
Answer Posted / nirav gajjar
The Data Pump is a server based utility vs. the traditional
Export / Import which are client based utilities. The
Oracle Data Pump is not compatible with the Export / Import
functionality.
The Oracle Data Pump can also use NETWORK_LINK
functionality to move data and metadata from a remote
database without a dumpfile using the network technology
between the two databases.
Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the different types of indexes available in sql server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what are the performance views in an oracle rac environment?
Can you redefine a table online?
How would you best determine why your MVIEW couldn't FAST REFRESH?
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
how can you implement fine-grained auditing?
Where would you look for errors from the database engine?
What are the different ways you can create databases in sql server? : sql server DBA
What is a system database and what is a user database? : sql server DBA
Why would you use sql agent? : sql server DBA
internal architecture
what do you understand by fine-grained auditing?