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 -> Re: Type of a DBA question urgent

Re: Type of a DBA question urgent

From: Greg Kainz <gkainz_at_orapro.com>
Date: 1997/12/04
Message-ID: <3486E0E5.D8E97AB1@orapro.com>#1/1

datafile 'test_system1' must exists prior to create controlfile. I also recommend full pathing in filename

Satish Narasimha wrote:

> hello,
> i tried to execute the following command and i got the foll
> error can anybody help me immediately.
>
> create controlfile
> 2> set database default
> 3> logfile group 1('logfile1a','logfile1b') size 250k,
> 4> group 2('logfile2a','logfile2b') size 250k
> 5> datafile 'test_system1' size 250k
> 6> resetlogs;
>
> create controlfile
> *
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01169: DATAFILE number 1 not found. Must be present
>
> I am not able to trace the error exactly can anybody help me to
> solve it.
>
> Thanks in advance.
>
> from
> satish :satishn_at_blr.sni.de
Received on Thu Dec 04 1997 - 00:00:00 CST

Original text of this message

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