Login  Register

impdp from 12c to 19c

Posted by Roshan on Dec 02, 2022; 11:50am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/impdp-from-12c-to-19c-tp11317.html

Hello Erman,

kindly advise why index count is lower on target when importing from 12c dump to 19c dump?
ppdsourcecount.txt
ppdtargetcount.txt

import parfile:

userid=system/888
dumpfile=X8_befmig_dump_full_01Dec22.dmp
directory=migg
full=y
logfile=imp_2Dec.elog
EXCLUDE=SCHEMA:"IN ('SYS'
,'SYSTEM'
,'DBSNMP'
,'APPQOSSYS'
,'GSMCATUSER'
,'XS$NULL'
,'MDDATA'
,'REMOTE_SCHEDULER_AGENT'
,'DBSFWUSER'
,'SYSBACKUP'
,'GGSYS'
,'ANONYMOUS'
,'SYSRAC'
,'CTXSYS'
,'OJVMSYS'
,'SI_INFORMTN_SCHEMA'
,'DVF'
,'PERFSTAT'
,'DVSYS'
,'AUDSYS'
,'GSMADMIN_INTERNAL'
,'DIP'
,'ORDPLUGINS'
,'MDSYS'
,'OLAPSYS'
,'LBACSYS'
,'ORDDATA'
,'SYSKM'
,'OUTLN'
,'ORACLE_OCM'
,'SYS$UMF'
,'XDB'
,'WMSYS'
,'ORDSYS'
,'SPATIAL_CSW_ADMIN_USR'
,'SYSDG'
,'GSMUSER'
)"


Regards,

Roshan