Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXCLUDE SCHEMA, EXCLUDE TABLES in full EXPDP export of database

user11969801Mar 14 2017 — edited Mar 14 2017

Hi All,

I am taking a full database export but i want to exclude a single schema and tables from multiple schema.

I am using below syntax in parfile.

FULL=Y

EXCLUDE=SCHEMA:"='FINNMIGR_BAFLAF'"

EXCLUDE=TABLE:"IN ('FINNLEA_AFPROD.NBFC_CHEQUE_DTL',

'FINNLEA_AFPROD.STATE_REGION_CIRCLE_TMP',

'FINNLEA_AFPROD.CIRCLE_DEFN_2W_3W',

'FINNLEA_AFPROD.LEA_ASSET_DTL',

I am not adding tables from 'FINNMIGR_BAFLAF' schema in EXCLUDE=TABLE:"IN syntax.

I tried using above method but it failed. Excluded tables are still in my dump.

Again after searching i found that in EXCLUDE=TABLE:"IN syntax, you can not use 'SCHEMA_NAME.TABLE_NAME'. You have to use only TABLE_NAME.

And if you are using only 'TABLE_NAME' in EXCLUDE=TABLE:"IN.. then tables having same name from all the schemas are excluded, which i don't want.

Please help.

Thanks.

Pranit

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2017

Added on Mar 14 2017

#database-key-features, #export, #export-import-sql-loader-external-tables

5 comments

47,657 views