Oracle Error ORA-31603 Encountered (Doc ID 2887089.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

User granted the SELECT_CATALOG_ROLE to a user but failed to execute DBMS_METADATA.GET_DDL

select * from user_role_privs;

USERNAME    GRANTED_ROLE                                   ADM DEL DEF OS_ COM INH
----------- ---------------------------------------------- --- --- --- --- --- ---
DEVUSER1    CONNECT                                            NO  NO  YES NO  NO  NO
DEVUSER1    SELECT_CATALOG_ROLE                        NO  NO  NO  NO  NO  NO

SELECT DBMS_METADATA.GET_DDL('VIEW','DBA_OBJECTS','SYS') from dual;

ORA-31603: object "DBA_OBJECTS" of type VIEW not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6718
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
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.

Remark : "SELECT DBMS_METADATA.GET_DDL('VIEW','DBA_OBJECTS','SYS') from dual;" work fine with a DBA user account

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.