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
- 5580 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 |
Give two examples of how you might determine the structure of the table DEPT.
Can we take incremental backups in datapump?
how can you connect from 10g user to 11g user??
What are the different ways you can create databases in sql server? : sql server DBA
What is the recommended interval at which to run statspack snapshots, and why?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between Datapump & export/import?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is dcl? : 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?
Give the stages of instance startup to a usable state where normal users may access it.
which background process will run @ the time of creation of catalog database
-
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)
