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
- 4818 Views
- iGate, I also Faced
- E-Mail Answers
Answer / 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 |
what is a crs resource?
If we issue alter database begin backup. What happens to database?
How to make a replica of existing oracle server to another server?
deleted of control file how will u recover control file?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
How does Oracle guarantee data integrity of data changes?
Explain what partitioning is and what its benefit is.
How can you control the amount of free space in your index pages? : sql server DBA
What is the difference between LMT & DLT?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
What is transparent data encryption? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
