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
- 5645 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
What are the different types of indexes available in sql server? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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?
What is dcl? : sql server DBA
internal architecture
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?
What is the default fill factor value? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Where would you look for errors from the database engine?
how can a session indicate its interest in receiving alerts?
who owns the operating system files created by the utl_file package?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
