Re: Help!!

varad acharya wrote:
>
> mwang wrote:
> >
> > Because I deleted a datafile from directory, I am not able to restart
> > Oracle. After I created a file, as suggested, with the same name and
> > size in the same directory, the error messages are:
> >
> > SQLDBA> connect internal;
> > Connected.
> > SQLDBA> start mount;
> Is /usr/people/mwang/data/abc.dbf the name of the new file you added?
> If so try the folowing.
>
> startup mount
> alter database datafile '/usr/people/mwang/data/abc.dbf' offline
> alter database open
>
> The oracle instance should startup albeit the above datafile will not
> be available.Data that was contained in the original file of this name
> is lost.
>
> --
>
> Regards,
>
> Varad Acharya

Thank you so much! I tried what you taught me to do. Now this is the result. What I should do next?

Thank you again!!!

Min Wang Received on Wed Oct 02 1996 - 00:00:00 CEST