Re: sql.bsq

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: 2000/09/20
Message-ID: <8qaus8$oe1$1@spiney.sierra.com>#1/1

What I did was:

Install a default database with minimum <small> datafiles.

Collect the scripts produced from $ORACLE_BASE/admin/orcl/create which includes these SQL scripts:
startorcl.sql
crdborcl.sql
crdb2orcl.sql
crdborcl.1st

Edit these scripts to be what you want (blocksize, system db size, etc)

Remove the installed default Oracle database. Install Oracle choosing to build the DB manually. Use svrmgrl to run the above edited scripts.

"Jerry" <america_at_usa.com> wrote in message news:VVxx5.3785$Ao3.22027_at_news1.atl...
> If I wanted to create a database manually in what
> sequence would I run this command. I think this way;
>
>
> 1) oradim ---------------- to create a new sid
> 2) sql.bsq
> 3) builddb.sql
> 4) buildall.sql
> 5) scripts to create application tables
>
> Thanks for your help
>
> Jerry
>
>
>
>
> > This script creates data dictionary tables and is executed
> > automatically at database creation.
> >
> > Roman Pysak
> >
> > In article <lhvx5.3783$Ku3.17938_at_news4.atl>,
> > "Jerry" <america_at_usa.com> wrote:
> > > What is the file "sql.bsq" used for.
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Sep 20 2000 - 00:00:00 CDT