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!

expdp to export multiple schemas

smeeAug 2 2012 — edited Aug 8 2012

Hi all,

I have a question related to Oracle Data Pump.

So, I want to export two schemas from database with condition:

1. I want to export scheme_1 with all metadata objects + data.
2. I want to export scheme_2 with only metadata objects.

Oracle version is Oracle EE 10.2.0.4.0, OS - Microsoft Server 2003R2.

As far as I know I can not use parameter EXCLUDE like: EXCLUDE =TABLES:" IN ('SCHEMA_NAME.TABLE')" (-but this parameter will give me no tables at all) or I can not use CONTENT=SCHEMA_NAME.METADATA_ONLY, maybe I can use QUERY=where table in (select tablename where schema is .... - but I have tables with same name in both schemas).

Maybe someone had same request and found solution.

Tnx in advice.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2012

Added on Aug 2 2012

#data, #database-key-features, #export, #export-import-sql-loader-external-tables, #schema, #table, #windows

7 comments

6,840 views