Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to create database?

How to create database?

From: Raymond Li <supercat_at_planet.net.hk>
Date: Tue, 19 May 1998 00:14:24 +0800
Message-ID: <35605E5F.5033C250@planet.net.hk>


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 Mon May 18 1998 - 11:14:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US