9 Replies Latest reply on Jul 15, 2014 1:59 PM by 942572

    Datapump to export certain tables

    942572

      Hi All,

      I would like to export certain tables via datapump. For example, all tables start with EMP, but not EMP_ADMIN. The following script does NOT work for me:

       

      expdp / SCHEMAS=MYSCHEMA INCLUDE=TABLE:"LIKE 'EMP%'" EXCLUDE=TABLE:"LIKE 'EMP_ADMIN%'" DUMPFILE=dpump_dir1:exp_inc.dmp NOLOGFILE=y

       

      Any suggestion on how to use the name clause in the INCLUDE parameter?

       

      Thanks!