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
- 5745 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 is ora 24313?what is the procedure to exclude that error?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What types of replication are supported in sql server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how does an oracle clusterware manage crs resources?
What are the recovery models for a database? : sql server DBA
what is logical system in sap basis
What is dcl? : sql server DBA
Can you redefine a table online?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
. 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?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
