Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v$instance - table or view does not exist.

DBA_1976Sep 13 2010 — edited Sep 13 2010
Hi,
I have a 10.2.0.3 database on RHEL 4. When I login as sysdba from the server, and then execute the sql stt. "select * from v$instance;" It gives the correct response. But when I am logged in as another user in the same instance, and execute this statement, I get table or view does not exist error. Why? Do I have to have some rights?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2010
Added on Sep 13 2010
#general-database-discussions
6 comments
12,901 views