2 Replies Latest reply: Jun 1, 2012 7:17 AM by Srini Chavali-Oracle RSS

    Not able to export Table with $ in name

    j_DBA_sourav
      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 /

      COUNT(1)
      ----------
      0


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



      -Rgards,
      Saha