m trDatapump but some tables just with metadata only
I want to export a database as a particular schema, but need to exclude data of some tables. I was planning on using the following: But a number of tables contain triggers and constraints, this seems to case issues when trying to do metadata first and then data second. The triggers are not created.
expdp user/pass directory=mydir dumpfile=mydumpfile.dmp log=mylog.txt content=metadata_only exclude=triggers,constraints
expdp user/pass directory=mydir dumpfile=mydumpfile.dmp log=mylog.txt content=data_only
once the metadata is loaded, then import the data
impdp user/pass directory=mydir dumpfile=mydumpfile.dmp log=mylog.txt content=metadata_only