Database ERRORS
ORA-02030: can only select from fixed tables/views
When we Grant the Select privilege on a V$ view we will get an ora-02030 error. As ORA-02030 says, that we can only select from fixed tables/views, which means V$INSTANCE is not a table or view. We know that actual view created on the dynamic performance table that is V_$. The Read more…