Re: Type of a DBA question urgent

You may want to specify complete path of the datafile starting from the file system mount point, meaning : something like '/u01/.../test_system1.dbf' to identify the exact data file name. The same way you should specify log files too.

Good luck.

Umesh

In article <34850F72.4B0B_at_blr.sni.de>,
  Satish Narasimha <satishn_at_blr.sni.de> 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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet