I'm trying to export a schema and then import it, but there are some huge tables that I must skip all the data from (that is, I need the tables and all stuff related to them, just not the rows).
So I thought I'd do
1) expdp SCHEMAS=X CONTENT=METADATA_ONLY DUMPFILE=meta.dmp 2) exportSCHEMAS=X CONTENT=DATA_ONLY EXCLUDE=TABLE:"IN \('FOO','BAR'\)" DUMPFILE=data.dmp
4) impdp SCHEMAS=X EXCLUDE=REF_CONSTRAINT DUMPFILE=meta.dmp 5) impdp SCHEMAS=X DUMPFILE=data.dmp
The plan is in step 4 to get all the meta data, and then in step 5 import all data but the rows in the large tables FOO and BAR, But how can I get the foreign keys?
Is this a way to do it, or are there other ways?