Originally posted by kris123
u can also update views if u have granted privileges on it.
Yes, they are accessible only if ur database is started up and open.

Thanks
Hi. I could be very wrong but just want to clarify that in the different stages of startup, these views and tables are subject to availability?


In additional, there are 3 stages of startup as belows

1) startup nomount (read the initsid.ora)

2) startup mount (only the control file is read)

3) startup open (all the datafiles)

Please advise.