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
What is the importance of a recovery model? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
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?
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
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you process messages in order asynchronously?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is the use of recording information about current session?
What are the different ways you can create databases in sql server? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Where do you find the default index fill factor and how to change it? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?