Re: creating a new database

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' Received on Sun Jul 28 1996 - 00:00:00 CEST