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
- 5552 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 |
deleted of control file how will u recover control file?
how can you connect from 10g user to 11g user??
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 would you extract DDL of a table without using a GUI tool?
what is the difference between catalog & nocatalog?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is the default port no on which sql server listens? : sql server DBA
Where do you find the default index fill factor and how to change it? : 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?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What types of replication are supported in sql server? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
