4 Replies Latest reply: Sep 4, 2013 7:03 AM by Srini Chavali-Oracle RSS

    Expdp with exclude giving error.

    dba.arnab

           Hello,

       

      Trying to export a schema excluding 1 table of it. Refer following comand.

       

      expdp \"/ as sysdba\" exclude=TABLE:'D_FEE_TRX' directory=STRUCTURE SCHEMAS=OYS_LOAD dumpfile=OYS_LOAD.dmp logfile=OYS_LOAD.log

       

      Error as below.

       

      Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 04 September, 2013 10:33:21

       

       

      Copyright (c) 2003, 2007, Oracle.  All rights reserved.

       

       

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      ORA-39001: invalid argument value

      ORA-39071: Value for EXCLUDE is badly formed.

      ORA-00920: invalid relational operator

       

       

      Please suggest.