title: export large number of tables using expdp
body: <p>My Environment has more than 4000 tables. I want to export only 2000 tables.
  I tried using par file using Include clause. But the export is failing.
  Details are mentioned below</p>
  
  <p>Tool: EXPDP | Oracle Database version:11g R2 | Number of tables to be exported: 2000</p>
  
  <p>Code used:</p>
  
  <pre><code>directory=pump
  dumpfile=EXP_FULL_GOLD.dmp
  logfile=EXP_FULL_GOLD.log
  COMPRESSION=ALL
  schemas=GOLD
  include=TABLE:"IN('T1','T2','T3','T4'..'T2000')
  </code></pre>
  
  <p>Error:
  With the Partitioning, OLAP, Data Mining and Real Application Testing options
  ORA-39001: invalid argument value
  ORA-39071: Value for INCLUDE is badly formed.
  ORA-00920: invalid relational operator</p>
  
  <p>Even I tried below code:</p>
  
  <pre><code>directory=pump 
  dumpfile=EXP_FULL_GOLD.dmp 
  logfile=EXP_FULL_GOLD.log 
  COMPRESSION=ALL 
  schemas=Gold
  content=DATA_ONLY
  INCLUDE=TABLE:\"IN \(SELECT tname FROM Gold.t11\)\"
  </code></pre>
  
  <p>Here T11 contains list of tables stored in Column tname (2000 records).</p>
  
  <p>But same error occurs.
  Please help as I searched on Net a lot, but I am not able to find any Solution.
  Even for Include clause Number of Tables allowed Limit is also not available anywhere. Tried using 900 tables but failed with same error.</p>
  
  <p>Regards,</p>
  
  <p>Sujit</p>