i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
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
how to restore files with rman?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
internal architecture
how does an oracle clusterware manage crs resources?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the diffrence between core dba and apps dba?
how can you record information about current session?
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.
which background process invoke at the time of upgradation tell me???
What types of replication are supported in sql server? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the operating modes in which database mirroring runs? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What the different components in replication and what is their use? : sql server DBA