2 Replies Latest reply on Jun 1, 2012 12:17 PM by Srini Chavali-Oracle

    Not able to export Table with $ in name

      Helllo All,

      I am using the below command to export a table which is present in the given schema but throwing error.

      expdp u_refresh/u_refresh@T1FSARC dumpfile=expdp_NEW_TABLE.dmp loggfile=expdpSCOTT_table_export.log tables="SCOTT"."DR\$IX_FS_FULLTXT\$N"

      Getting below error.

      Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
      Total estimation using BLOCKS method: 0 KB
      ORA-39165: Schema SCOTT was not found.
      ORA-39166: Object DR$IX_FS_FULLTXT$N was not found.
      ORA-31655: no data or metadata objects selected for job
      Job "U_REFRESH"."SYS_EXPORT_TABLE_01" completed with 3 error(s) at 17:19:43

      Where as I get below O/P in Database:
      SQL> select count(1) from SCOTT.DR$IX_FS_FULLTXT$N
      2 /


      How can I export and import this table. Please help.