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: sys tables missing

Re: sys tables missing

From: pady srinivasan <pady_at_imncorp.com>
Date: 1997/10/02
Message-ID: <3433A6D0.9D96C7D3@imncorp.com>#1/1

This is a multi-part message in MIME format.

--------------A5B77A8DC4C49A3C18F68E89
Content-Type: text/plain; charset=iso-8859-1
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Content-Transfer-Encoding: 8bit

If you are not finding any of the 'DBA_' or 'v$' views, then run the following
'sql' scripts:

As user 'sys': ORACLE_HOME/rdbms/admin/catalog.sql

                        ORACLE_HOME/rdbms/admin/catproc.sql

As user 'system': ORACLE_HOME/sqlplus/admin/pupbld.sql

Pady Srinivasan
pady_at_imncorp.com

Kim Wykoff wrote:

> 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

--
MZ


--------------A5B77A8DC4C49A3C18F68E89
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for pady  Srinivasan
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             pady  Srinivasan
n:              Srinivasan;pady 
org:            Integrated Medical Networks
email;internet: pady_at_imncorp.com
title:          Oracle DBA/UNIX sysadmin
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
end:            vcard


--------------A5B77A8DC4C49A3C18F68E89--
Received on Thu Oct 02 1997 - 00:00:00 CDT

Original text of this message

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