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!

ora-00942 table or view does not exist

667075Oct 28 2008 — edited Jun 14 2011

Hello folks,

I have created a new database in my system and started to learn from the scratch.
I have installed oracle 10g standard edi in Window XP.
After creating the pfile and database,when i type the below mentioned query, it throws the
error ora-00942 table or view does not exist.

query: select file_name from dba_data_files;

i entered the sql as an OS user ( sqlplus / as sysdba )

please help me.

Thanks,
Khan.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2011

Added on Oct 28 2008

#general-database-discussions

17 comments

9,334 views