Re: sys tables missing

From: Lee Johnson <hpj_at_ctm*ed.com>
Date: 1997/09/25
Message-ID: <60dq3q$n35@news-central.tiac.net>#1/1

How are you logged in to Oracle. I'm pretty new to this myself, but as I understand it, users can only see their own tables unless the tables are altered to allow others to see them. You probably don't want to do this for the system tables, but, if you log in as sys or system, you should be able to see the tables. Some interesting tables to look at are all_tables and all_tab_columns - they contain the info about any tables and their columns.

Hope this helps,

--
Lee Johnson
harley.johnson_at_s*net.net
(to reply, move the * in my address)

Kim Wykoff wrote in article <34298FA5.A2FEB1D6_at_mail.dec.com>...



>The oracle documentation says that whenever you create a database, the

>system tablespace is created, creates the data dictionary, and the users

>sys and system are created.

>

>So far I haven't seen this happen.  Whenever I create a database, I

>can't see any tables (it says they don't exist).  I know it is holding

>the information somewhere, at least about the users because when I try

>to add a user, I can connect as that user.

>

>I don't know what I'm doing wrong.  I have a feeling that the tables are

>there, I just can't see them.

>

>thanks,

>

>kim

>

Received on Thu Sep 25 1997 - 00:00:00 CDT