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:
- Open the database from MOUNT state, then query it again.
- Query the dynamic dictionaries V$TABLESPACE instead, which is allowable to be queried at mount state.