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
Where would you look for errors from the database engine?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
how can you enable flashback feature?
what is asm?
What purpose does the model database server? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
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
What is the importance of a recovery model? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
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