My Oracle Support Banner

Oracle Error ORA-31603 Encountered (Doc ID 2887089.1)

Last updated on AUGUST 24, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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