I've recently started to split out schema mode imports using Data Pump import to two steps as suggested to me to improve performance - 1 with "exclude=constraint,index,statistics" and the second with "include=constraint,index,statistics".
In my most recent test environment refresh, I have been informed that the check constraints weren't imported. I've done a check of dba_constraints and it certainly appears that way. Prod has 1629 check constraints for the refreshed user and the test environment has 30.
My command line options:
impdp system@testpdb1 schemas=<schema list> table_exists_action=replace
dumpfile=schemasbackup-prod-20160212-0100.dmp directory=REFRESH
exclude=index,constraint,statistics
impdp system@testpdb1 schemas=<schema list> table_exists_action=replace
dumpfile=schemasbackup-prod-20160212-0100.dmp directory=REFRESH
include=index,constraint,statistics
This is a full export from the production system (11.2.0.3.0), importing to 12.1.0.2, and the same dump has been used to refresh another 11.2.0.4 system without the exclude/include options which worked as expected.
What am I missing? I can't see any options for impdp which suggest that this shouldn't work.
Added versions and full note