ORA-39166 ORA-31655 When Exporting a Table With '$' Character in The Table Name
(Doc ID 2397873.1)
Last updated on MAY 18, 2021
Applies to:Oracle Database - Standard Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
How can I export a table with $ character in the table name without getting errors ORA-39166 and ORA-31655?
ORA-39166: Object TEST$1 was not found.
ORA-31655: no data or metadata objects selected for job
expdp ... tables=CTXSYS.DR$CLASS:
ORA-39165: Schema CTXSYS was not found.
ORA-39166: Object DR$CLASS was not found.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document