10 Replies Latest reply: Sep 6, 2012 3:00 AM by user5716448 RSS

    expdp - tables

    user5716448
      Hi,

      Have a parfile to export tables and currently have them listed as

      TABLES=TABLE1,TABLE2 etc but will have over 30 or so tables.

      Can we use a query to export the tables name
      e.g TABLES="SELECT TABLE_NAME
                          FROM USER_TABLES
                          WHERE TABLE_NAME LIKE '%BAK%'"
      Have tried above but get

      ORA-31655: no data or metadata objects selected for job


      guess wrong sytnax if possible.
      tHANKS

      Edited by: user5716448 on 05-Sep-2012 05:53