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
- 5751 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
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you initialize log miner?
How do you trace the traffic hitting a sql server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is a crs resource?
which background process invoke at the time of upgradation tell me???
what is the use of recording information about current session?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
how to restore files with rman?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
