| Is my data dictionary corrupt [message #62021] |
Sat, 19 June 2004 19:38  |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
HI
WHY AM I GETTING THIS ERROR.
SQL> select object_name,status from dba_objects where object_name like 'DBA_DATA%';
OBJECT_NAME STATUS
-------------------- -------
DBA_DATA_FILES VALID
DBA_DATA_FILES VALID
DBA_DATA_FILES VALID
SQL> select * from DBA_DATA_FILES;
select * from DBA_DATA_FILES
*
ERROR at line 1:
ORA-00942: table or view does not exist
REGARDS
satish
|
|
|
|
| Re: Is my data dictionary corrupt [message #62023 is a reply to message #62021] |
Sun, 20 June 2004 21:26  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
You are connected as a user that doesn't have access to the DBA_DATA_FILES view. Your user can however query the DBA_OBJECTS view, so you know the DBA_DATA_FILES view exists.
It is a question about access rights.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
