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_DATA_FILES "does not exist" but listed from ALL_OBJECTS

JackKSep 8 2014 — edited Sep 8 2014

Hi,

I have:

select object_name from all_objects where object_type in ('TABLE','VIEW') and object_name = 'DBA_DATA_FILES';

OBJECT_NAME

--------------

DBA_DATA_FILES

1 row selected

select file_name from DBA_DATA_FILES;

ORA-00942: table or view does not exist

00942. 00000 - "table or view does not exist"

*Cause:

*Action:

Error at Line: 2 Column: 23

Why is that?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2014

Added on Sep 8 2014

#general-database-discussions

12 comments

5,333 views