Interested to Buy Any Domain ? << Click Here >> for more details...
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
- 1 Answers
- 5588 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
You should implement parallelisim
e.g.,
expdp full=y directory=data_pump dumpfile=dumpfile%U.dmp
logfile=logfile_exp.log parallel=5 filesize=10G
exclude=statistics
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
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?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you implement fine-grained auditing?
what is logical system in sap basis
how can you process messages in order asynchronously?
What is a system database and what is a user database? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What is dbcc? : sql server DBA
how can you initialize log miner?
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 is dcl? : sql server DBA
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
. 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?
