Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9 bare install, OMF, can't see dba_tables...
On 30 Nov 2005 19:01:11 -0800, "George" <george.cross_at_excite.com>
wrote:
>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
Obvious question: you did read the docs carefully and ran
?/rdbms/admin/catalog.sql
and
?/rdbms/admin/catproc.sql
otherwise dba_tables etc simply don't exist, and dbca runs those scripts for you under the hood.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Dec 01 2005 - 00:25:03 CST