6 Replies Latest reply: Jan 28, 2014 2:43 AM by Baris Yildirim RSS

    V$ and DBA tables


      I am logged in as SYS

      I started the database in mount mode.

      I get select results from v$instance and v$database ---->I think these are dynamic views where data is grabbed from the instance so I see data.

      But I see no result for  dba_data_files-->I think dba_data_files is a fixed table in the SYS schema.But as the database is not yet open we cannot access the table data.

      Are my conclusions right ?