Re: Type of a DBA question urgent

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

Hi,

try including full path specification in your filenames.

-- 
Regards

Matthias Gresz    :-)