Home » RDBMS Server » Server Utilities » How to exclude Multiple tables by using EXPDP
How to exclude Multiple tables by using EXPDP [message #687926] Sun, 23 July 2023 04:43 Go to next message
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 Go to previous message
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
Senior Member
dba_senior wrote on Sun, 23 July 2023 12:43
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!


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

Previous Topic: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll
Next Topic: how to parametrize values in pl/sql block
Goto Forum:
  


Current Time: Wed Apr 24 04:59:42 CDT 2024