ragu.dba.in wrote:Just a nitpick, on my system expdp takes 1 hour 15 minutes, while exp DIRECT=Y takes 1 hour 3 minutes. YMMV. On some systems and versions, metadata processing can make a big difference.
why not datapump? it is faster...
expdp system/manager@xyz FULL=Y DUMPFILE=FULL.DMP log=full_log.logMaybe. Maybe not. There are some dependencies which sometimes come up. It's worth a try, needs to be tested.
FULL.DMP is stored in default directory data_pump_dir location.copy to target server's data_pump_dir location .
CREATE FOLDER STRUCTURE IN THE TARGET SERVER SAME AS IN SOURCE SERVER.
impdp system/manager@abc FULL=Y DUMPFILE=FULL.DMP log=full_log.log
all would be taken care.no need to create schema,tablespace,grants etc...