Re: sql.bsq

True, Van, true. I hated to say it too... so I didn't ;-)

Actually, the database assistant is pretty good, especially at all listener.ora and tnsnames.ora things you mentioned. I'd forgotten about that!!

Cheers,
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Van Messner" <vmessner_at_bestweb.net> wrote in message
news:rEyx5.189$VQ.31572_at_newshog.newsread.com...


> 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.

> > >

> > >

> >

> >

>

>