Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: sql.bsq
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...Received on Mon Sep 18 2000 - 20:16:57 CDT
> 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.
>
>