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 dbcc? : sql server DBA
how can you record information about current session?
how can you implement fine-grained auditing?
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?
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
What are the recovery models for a database? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
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
how can you communicate with operating system files from oracle?
Where would you look for errors from the database engine?
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?
What types of replication are supported in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?