ORA-4043 On DBA_* Views If They Are Described In Mount Stage (Doc ID 296235.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

If you describe any DBA_* Views (Data dictionary views) in a mount stage, than you will not be able to 
 describe those views even after opening the database.

You can test as follows:

+ Shutdown the database.

SQL> Shutdown immediate

+ Mount the database.

SQL> Startup Mount

+ Describe any Data Dictionary view.

SQL> DESC DBA_DATA_FILES

ERROR:
ORA-04043: object DBA_DATA_FILES does not exist.

+ Open the Database.

SQL> ALTER DATABASE OPEN;

Database altered

+ Describe the same Data Dictionary view.

SQL> DESC DBA_DATA_FILES

ERROR:
ORA-04043: object DBA_DATA_FILES does not exist

*** Error will appear till we bounce the Database / flush the shared pool.

Cause

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