Re: sql.bsq

Or - I hate to say it - If you are running any version of 8i, you can use the GUI database creation assistant and have Oracle handle everything in the correct order including adding parameters to your tnsnames.ora and listener.ora and bouncing the listener.

Van

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:39c6b013$1_at_news.iprimus.com.au...
> Well, I tend not to use 'builddb' scripts, so I can't vouch for what is in
> there, but I'd wager a small sum that somewhere it includes the command
> 'create database xxx etc etc etc', and if that is so, then you can forget
> your point 2... sql.bsq doesn't need to be run by us mere humans, but is
> called automatically as part of the 'create database' process.
>
> Again, I don't know what's in the buildall.sql script, so I can't comment.
>
> The order in principle should be: Prepare an init.ora, use Oradim to
 create
> the services (I take it this is NT?), connect to the Instance in NOMOUNT
> stage, issue the 'create database' command, run catalog.sql, run
> catproc.sql, start building your own application tables.
>
> Regards
> HJR
>
> --
> --------------------------------------------------------------------------
> Opinions expressed are my own, and not those of Oracle Corporation
> Oracle DBA Resources: http://www.geocities.com/howardjr2000
> --------------------------------------------------------------------------
>
>
>
> "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 Mon Sep 18 2000 - 19:43:03 CDT