* I want to import data first then indexes, constraints, etc.
* Export did not include statistics.
* I have manually created the tables first.
* IMPDP script =>
impdp \'sys/Pswd as sysdba\' remap_tablespace=ORIG_DATA_1:NEW_DATA_1,ORIG_INDX_1:NEW_INDX_1 remap_schema=ORIG:NEW DUMPFILE=orig3_prl10_nostat_%u.dmp DIRECTORY=dump_dir content=data_only TABLES=ORIG.ORDERS parallel=10 LOGFILE=impdp_orig10_3_data.log
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "NEW"."ORDERS" 251.6 GB 726206339 rows
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/AUDIT_OBJ
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Why do I see object_grant, audit_obj,constraint? What am I missing in my syntax to just do the data only.....THEN import the rest of the things? Do I need to exclude=index,constraint,object_grant,audit_obj then include them?
Cannot find anything regarding this online.