Re: creating a new database

Tim V. Nimmo wrote:
>
> Kristoffp <kristoffp_at_aol.com> wrote in article
> <4tb1dt$t3q_at_newsbf02.news.aol.com>...
> > Hi world,
> > Sorry for this question, but I'm a oracle novice.
> > I tried to create a new database with the following steps:
> >
> > 1) copied init.ora to openroadinit.ora, and change the
> > db_name-parameter to openroad.
> > 2) Set ORACLE_SID to openroad.
> > 3) Called sqldba
> >
> > - connect internal
> > - startup nomount
> > - create database openroad
> > datafile '/data3/oracle2/openroad/openroad_system' SIZE 2M,
> > logfile group 1 ('/data1/oracle2/openroad/log1.log',
> > '/data3/oracle2/openroad/log1.log') SIZE 100K,
> > group 2 ('/data1/oracle2/openroad/log2.log',
> > '/data3/oracle2/openroad/log2.log') SIZE 100K,
> > character set we8dec;
> >
> >
> >
> > I get the followin errormessage:
> >
> > logfile group 1 ('/data1/oracle2/openroad/log1.log',
> > *
> > ORA-02236: invalid file name
> >
> >
> >
> > All directories exists.
> > So what is wrong ?
> >
> > Thanks for any answer
> > Kristoff
> >
> Oracle syntax is 'filename' [size clause]
>
> As in '/u/db/z.dbf size 2M. Re-examine your use of parenthesis'

Copy the original init.ora, config.ora, crdb.sql and crdb2.sql scripts to init"db name".ora, etc. then edit those scripts the way you want to configure your new database. Then simply run crdb"db name".sql, then crdb2"db name".sql in sqldba. Received on Tue Jul 30 1996 - 00:00:00 CEST