You must put the full path name in the logfile,datafile, etc...
'xxx/xxx/xxx' file names
--
In an effort to avoid the un-solicited e-mail
from the spammers of the world, I have added
no-spam to my e-mail address. To reply, etc...,
remove no-spam from the address.
-tw
UMESH.X.TIWARI_at_x400gw.ameritech.com wrote in article
<881243998.16535_at_dejanews.com>...
> 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
>
Received on Mon Dec 08 1997 - 00:00:00 CST
