This discussion is archived
2 Replies Latest reply: Jun 1, 2012 5:17 AM by Srini Chavali-Oracle RSS

Not able to export Table with $ in name

j_DBA_sourav Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points