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
- 5135 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 do you understand by flashback feature of oracle?
what are the benefits of flashback feature?
How can you gather statistics on a table?
how can you record information about current session?
Name a tablespace automatically created when you create a database.
What are the different ways you can create databases in sql server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Can we take incremental backups in datapump?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Give the stages of instance startup to a usable state where normal users may access it.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Where do you find the default index fill factor and how to change it? : sql server DBA
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
