SQL & PL/SQL

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!

Can't select from view even though it appears in ALL_VIEWS

user1983440Jan 5 2010 — edited Feb 11 2010

Oracle's documentation states that all_views "describes the views accessible to the user":

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2117.htm

DBA_OBJECTS appears in the ALL_VIEWS, yet I get a "table or view does not exist" error when I try to select from it.

Any thoughts on why this is happening?

SQL> SELECT COUNT(1)
  FROM all_views
  WHERE owner = 'SYS'
  AND view_name = 'DBA_OBJECTS'

  COUNT(1)
----------
         1
1 row selected.
SQL> SELECT *
  FROM sys.dba_objects
SELECT *
  FROM sys.dba_objects
           *
Error at line 2
ORA-00942: table or view does not exist

This post has been answered by Sanjeev Chauhan on Jan 5 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2010

Added on Jan 5 2010

8 comments

5,350 views