Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9 bare install, OMF, can't see dba_tables...

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 01 Dec 2005 07:25:03 +0100
Message-ID: <ln5to1djkak6gq67dlbngn5tvc11p5ucko@4ax.com>


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 DBA
Received on Thu Dec 01 2005 - 00:25:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US