export

Posted by Roshan on Oct 26, 2016; 11:00am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/export-tp1445.html

Hello Erman,

Source Database : Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 (linux)
Target database: 12c(windows Server 2012 R2)
 
Hello,
 
I want to do an export to oracle database 12C on Windows. My source database is Linux- 10.2. Is the script below ok?
 
expdp \"SYS@lfiche AS SYSDBA\"  version=10.2 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

Thanks,
Roshan