-
ORA-31603: object "string"
of type string not found in schema "string"
-
Cause: The
specified object was not found in the database.
-
Action: Correct
the object specification and try the call again.
Many Oracle
users find themselves encountering ORA-31603 when using
DBMS_METADATA.
The symptoms of this particular problem are defined as:
using
DBMS_METADATA package against tables defined with partitions to
generate DDL when the column contains unused columns raises
ORA-31603.
The reason
ORA-31603 is encountered in cases such as these is because, "unused
columns defined on the table cause Metadata retrieval issue"
The resolution to ORA-31603 is also given:
Solution confirmed by performing the following steps:
1. Drop unused columns from the table(s)
2. Retry metadata generation with
DBMS_METADATA package.
