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_tables

Sashi MadurMay 13 2010 — edited May 13 2010

When I describle dba_tables either from sysdba login or a user with dba login. I get the following error.

ORA-00942: table or view does not exist

I can access all othe dba_ views. This is on a 10g test database. I don't know whether it was like this from the beginning or I messed up something. I noticed this right after moving a datafile (non system related) to a different folder. I am not sure how that will affect any dba_ views.

Does anybody have any idea on how to troubleshoot this?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2010

Added on May 13 2010

#general-database-discussions

5 comments

3,122 views