ORA-31603: object “XTBL” of type TABLE not found in schema “SYS”
Cause:
This error occurs due to scanning of user table under sys owner.
kIsH@x3z6zx9<^>!oerr ora 31603
31603, 00000, "object \"%s\" of type %s not found in schema \"%s\""
// *Cause: The specified object was not found in the database.
// *Action: Correct the object specification and try the call again.
ERROR:
ORA-31603: object "XTBL" of type TABLE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 5805
ORA-06512: at "SYS.DBMS_METADATA", line 8344
ORA-06512: at line 1
Action:
Provide the right owner of the table.
kIsH@x3z6zx9<^>select DBMS_METADATA.GET_DDL('TABLE','XTBL','KISH') from dual;
DBMS_METADATA.GET_DDL('TABLE','XTBL','KISH')
--------------------------------------------------------------------------------
CREATE TABLE "KISH"."XTBL"
( "NAME" VARCHAR2(100),
"XID" NUMBER(20,0),