AW: EXPDP exclude 302 tables

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_at_gmail.com> An: "Howard Arthur Latham" <howard.latham_at_rsmb.co.uk>      

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 <mailto: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-l