Re: EXPDP exclude 302 tables
From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 10 May 2022 13:28:53 +0100
Message-ID: <CAPCNhx3Q4n26zYjJVsTz1rh9O+-yAZ5r6+o51Xuqq1bDwN0nAg_at_mail.gmail.com>
Date: Tue, 10 May 2022 13:28:53 +0100
Message-ID: <CAPCNhx3Q4n26zYjJVsTz1rh9O+-yAZ5r6+o51Xuqq1bDwN0nAg_at_mail.gmail.com>
Well what do you know? ! I found the solution.
Found the solution:
SCHEMAS=GOLD
DIRECTORY=DEBUG
COMPRESSION=ALL
CONTENT=DATA_ONLY
DUMPFILE=EXP_GOLD_26Jul2017.dmp
LOGFILE=EXP_GOLD_26Jul2017.log
INCLUDE=TABLE:"IN(SELECT TNAME FROM GOLD.T11)"
Best Wishes
Howard A. Latham
On Tue, 10 May 2022 at 13:25, Howard Latham <dmarc-noreply_at_freelists.org> wrote:
> Hi Oraclefans,
>
> Oracle 19.14
> RH 7.9
>
> What's the best /easiest way to exclude 302 tables in a datapump export.
> Can I put a select statement in the EXCLUDE parameter?
>
> I've searched the Doc and I can only find say 5 tables max in an IN
> statement.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 10 2022 - 14:28:53 CEST