why Datapump is faster than traditional export and import
Answer Posted / rizwan
In traditional datapump exp/imp utility we can not stop the job when it's processing.
whereas in newly expdp/impdp utility we can stop and restart the job
for example, we are exporting the 5 mb size of table and,suppose we want to stop this job so it is possible in expdp but not through exp utility.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Why does Oracle not permit the use of PCTUSED with indexes?
Explain about your sql server dba experience? : sql server DBA
What are the recovery models for a database? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
who owns the operating system files created by the utl_file package?
What purpose does the model database server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is replication? : sql server DBA
Why would you use sql agent? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how can you communicate with operating system files from oracle?