Oracle9 bare install, OMF, can't see dba_tables...

Giganews Newsgroups
Subject: Oracle9 bare install, OMF, can't see dba_tables...
Posted by:  George (george.cro…@excite.com)
Date: 30 Nov 2005

Dear All,

I installed Oracle9, and instead of running dbca, I created my db
instance according to the docs whereby I copied the init.ora file and
modified the parameters therein to generate the control file.

This worked great, and I was able to create my database, and tables in
it.  I can execute queries on the tables I created successfully.

However, when I execute

sqlplus> select * from dba_tables;

I always get,

ORA-00942: table or view does not exist

This is true for all_tables, or dba_tablespaces too.  Is there some
other trick so I can see all the tables in my db?

Thank you much.  Sincerely,

George

Replies