| How to exclude Multiple tables by using EXPDP [message #687926] |
Sun, 23 July 2023 04:43  |
 |
dba_senior
Messages: 1
Registered: July 2023
|
Junior Member |
|
|
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!
|
|
|
|
| Re: How to exclude Multiple tables by using EXPDP [message #687941 is a reply to message #687926] |
Fri, 28 July 2023 06:20  |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
dba_senior wrote on Sun, 23 July 2023 12:43Hi,
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!
I Can't answer from my memory, but I suggest you do the following:
1. Find some code on the WWW ( prefarably official Oracle docs ) about how to exclude tables, with a synthax that addresses schema names.
2. Prepare a schema A & schema B, both on the same test database, both with tables TAB1 & TAB2
3. run the xpdp in a command or with a parfile to execlude A.TAB1, B.TAB1..
See how it goes..
Regards,
Andrey
[Updated on: Fri, 28 July 2023 06:20] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
