Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Type of a DBA question urgent
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