How to Resolve ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

  • by

ORA-01219

Tried to query a data dictionary, but it failed with ORA-01219.

SQL> select * from dba_tablespaces;
select * from dba_tablespaces
              *
ERROR at line 1:
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

Solutions

ORA-01219 means that the data dictionary is not allowable to be queried at mount state. To solve the error, you should do either of the following ways:

  1. Open the database from mount state then query it again.
  2. Query the dynamic dictionaries V$TABLESPACE instead, which is allowable to be queried at mount state.

Leave a Reply

Your email address will not be published. Required fields are marked *