Re: Question on Installing Oracle.

Haven't looked at it recently - doesnt DBCA handle that situation?

The first thing that is run is the SQL.BSQ file - that sets up all the SYS tables and views. Messing around with that file on your own can cause total and permanent brain damage - to the database (and potentially all future databases on the machine) as well. Howver, a quick email to Oracle Support (through http://techet.oracle.com) should provide the information you are looking for.

Other than that - assuming your existing one is built using standard default OFA layout, look for the Oracle_Base/Admin/[sid]/create directory - you might find the supplementary create scripts there (if you didn't get the default database as a copy from the CD started database).

HtH
/Hans

"Kev.-" wrote:

> Hello All,
>
> I need to re-install oracle without the installer as it makes the
> database pretty much useless except for playing around with it. Where
> can I find dierctions on how to do it by hand.
>
> What files to run, etc...
>
> For example witht the installer the system tablspace is too small and
> it always gets fragmented due to the initial and next are set just to
> small.
>
> Please help anyone as I am in dire need of doing this ASAP.
>
> Thanks,
>
> Kev.-
  Received on Mon May 14 2001 - 21:06:38 CDT