Skip to Main Content

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!

DBA_USERS

524447Aug 28 2006 — edited Sep 4 2006
My database is working in very strange way

SQL> Select * from DBA_USERS;
Select * from DBA_USERS
*
ERROR at line 1:
ORA-00942: table or view does not exist

Is this possible?
DB version : 9.0.1.1.1
I am connected as sys as sysdba.

And if I do a select from dictionary for this view; it exists in the dictionary.

SQL> Select * from dict where table_name like 'DBA_US%';

TABLE_NAME
------------------------------
COMMENTS
---------------------------------------------------------

DBA_USERS
Information about all users of the database

DBA_USTATS
All statistics collected on either tables or indexes


What is wrong?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2006
Added on Aug 28 2006
4 comments
1,001 views