Re: export

Posted by Roshan on Oct 26, 2016; 1:53pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/export-tp1445p1450.html

Thanks for the tips.

Is invoking export as sysdba a good practice?
My target is Windows. The directory structure is different as in linux. Do I need to use  remap_datafile or create all the tablespaces only ? My target oradata(location of dbf) are in E:\oradata\lfiche on Windows.

I have modified my script as below:

production(source - 10g):

expd system/M@lfiche dumpfile=PMTBIL01`(date +"%d%m%Y%H%M")`.dmp logfile=PMTBIL01.expdp.`(date +"%d%m%Y%H%M")`.log FULL=Y EXCLUDE=TABLE:"IN('INVOICE')" directory=myxport exclude=statistics

target(Windows):

impdp system/M@lfiche dumpfile=PMTBIL01`(date +"%d%m%Y%H%M")`.dmp logfile=PMTBIL01.expdp.`(date +"%d%m%Y%H%M")`.log FULL=Y EXCLUDE=TABLE:"IN('INVOICE')" directory=myxport exclude=statistics