Hi,
I'm not sure how many tables should be exported in your case. But I think
the INCLUDE works only until certain limit.
I had similar issue when using a restriction on partitions in 12.2.
Everything beyond a certain limit is silently ignored.
Best regards
Ahmed
-----Original-Nachricht-----
Betreff: Re: EXPDP exclude 302 tables
Datum: 2022-05-10T14:29:37+0200
Von: "Howard Latham" <howard.latham@xxxxxxxxx>
An: "Howard Arthur Latham" <howard.latham@xxxxxxxxxx>
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@xxxxxxxxxxxxx
<mailto:dmarc-noreply@xxxxxxxxxxxxx> > 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.