why Datapump is faster than traditional export and import
- 4 Answers
- 19842 Views
- Mphasis, I also Faced
- E-Mail Answers
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
how can you implement fine-grained auditing?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
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?
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
who owns the operating system files created by the utl_file package?
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 can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
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 is a system database and what is a user database? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is asm?
