Hi..

Thanks for all who taught me. i tried and get the below

ORA-01219: database not open: queries allowed on fixed tables/views only

Cheers!

01219, 00000, "database not open: queries allowed on fixed tables/views only"
// *Cause: A query was issued against an object not recognized as a fixed
// table or fixed view before the database has been opened.
// *Action: Re-phrase the query to include only fixed objects, or open the
// database.

Just 2 more confirmation

1) Since the above indicates that there are fixed views, and with my example, v$session can be selected in the startup nomount stage, therefore, it is not a fixed view since it can only be selected after a database open.

2) what are the other fixed views?

Please advise.