-
How to exclude Multiple tables from Multiple schema by using EXPDP
Hi,
I'd like to export these 5 schemas:
ATR1
ATR2
ATR3
ATR4
ATR5
but exclude the following tables from schema ATR5 only:
TAB1
TAB2
TAB3
table TAB2 is also present in the Schema ATR2
Do you think this parfile is correct?
DIRECTORY=DPUMP
LOGFILE=EXP_PROD.log
DUMPFILE=EXP_PROD_%U.dmp
PARALLEL=4
SCHEMAS=ATR1,ATR2,ATR3,ATR4,ATR5
EXCLUDE=TABLE:"IN ('TAB1','TAB2','TAB3')"
Thanks in advance!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|