impdp using parfile containing EXCLUDE=INDEX and EXCLUDE=SCHEMA:"IN('SYS','SYSMAN','SYSTEM','OUTLN')
We took full database export from 11.2.04. database (db1) using following parfile :
userid='/ as sysdba'
PARALLEL=16
CONTENT=ALL
COMPRESSION=ALL
directory=TEST_DIR
dumpfile=expdp_db1_full_%U.dmp
logfile=expdp_db1_full_01.log
full=y
EXCLUDE=STATISTICS
We tried to do the import to 12.1.0.2 database, using following parfile, and still the indexes are getting imported,
directory=dir1
dumpfile=expdp_db1_full_%U.dmp
logfile=impdp_db1_full_01.log
parallel=16
full=y
exclude=SCHEMA:"IN('SYS','SYSMAN','SYSTEM','OUTLN','ORDDATA')"
exclude=INDEX
table_exists_action=replace
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
CLUSTER=Y
Not sure why the indexes are getting imported, inspite of mentioning EXCLUDE=INDEX
1