Re: How to create database?

Raymond Li 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> datafile 'f:\pianodb\piano.dbf' size 40M;
> create database pir
> *
> ORA-01501: CREATE DATABASE failed
> ORA-01100: database already mounted

You have to start your database with nomount option.

--

Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com

------------------------------------------------------------