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
- 5674 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 different types of indexes available in 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 the different topologies in which replication can be configured? : sql server DBA
What is dcl? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what are the differences of where and if in SAS?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is the use of ocr?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is fill factor? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
