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
which background process invoke at the time of upgradation tell me???
What is the default port no on which sql server listens? : sql server DBA
What are the recovery models for a database? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are the commands you'd issue to show the explain plan for "select * from dual"?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Why does Oracle not permit the use of PCTUSED with indexes?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what functionality does oracle provide to secure sensitive information?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you connect from 10g user to 11g user??
how can you initialize log miner?
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?