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),

Leave a Reply