4 Replies Latest reply on Sep 4, 2013 12:03 PM by Srini Chavali-Oracle

    Expdp with exclude giving error.




      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 - 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 - 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.