Re: How to create database?

Looks to me like you're missing an additional single-quote before the logfile datafile spec..

cpw

In article <35605E5F.5033C250_at_planet.net.hk>, supercat_at_planet.net.hk wrote:

> Hello,
>
> I have created a ora file initabc.ora. And I am trying to create
> database.
>
> After connecting using internal, I tried the following commands to
> create the database but both of them failed. I am using Windows NT 4 and
> Oracle Workgroup server 7.3.
>
> Raymond Li Cheuk Fai
>
>
> SQLWKS> create database pir
> 2> maxdatafiles 200
> 3> logfile f:\pianodb\piano1.log',
> 4> f:\pianodb\piano2.log' size 15M,
> 5> datafile 'f:\pianodb\piano.dbf' size 40M;
> logfile f:\pianodb\piano1.log',
> *
> ORA-02236: invalid file name
>
>
> SQLWKS> create database pir
> 2> maxdatafiles 200
> 3> datafile 'f:\pianodb\piano.dbf' size 40M;
> create database pir
> *
> ORA-01501: CREATE DATABASE failed
> ORA-01100: database already mounted
Received on Fri May 22 1998 - 00:30:55 CDT