How does oracle accesses v$ tables or views in mount state
Hi All,
I want to know how oracle accesses fixed tables/views while the database is in mount state.
I did the following:
1. Started the database in mount state.
2. Query v$database ,v$datafile--Successful
3. Queried dba_data_files.---ERROR
---------------------------------------------------------------------------------------------------------
SQL> select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
----------------------------------------------------------------------------------------------------------
As per my understanding goes,all these tables are a part of Data Dictionary which is stored physically on system tablespace.
Now since the database is mounted ,it cannot access any part of system tablespace's data.Am I right??
So how does it queries v$ tables and other fixed database tables in mount state???
Thanks in advance
Saket Bansal