Re: How do you drop a user if the .dbf file it references has been deleted?

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Tue, 22 Jan 2002 16:41:36 -0000
Message-ID: <a2k4ph$2en$1@thorium.cix.co.uk>

Hi,

Oracle is complaining that there is a datafile missing and it wont open the database until the file has been recovered or you could recreate the control file to exclude the file that's missing - you could loose data though assuming there were tables in the datafile / tablespace that's missing.

Let me know if you want to recreate the control file and I'll send you some notes on the procedure.

Alistair

"some joe" <hartj_at_logica.com> wrote in message news:454f97e7.0201220836.77e9e910_at_posting.google.com...
> Before I start I would like to add that I am fairly new to Oracle, so
> please be gentle!
>
> A user was created that referenced a .dbf file that has since been
> deleted. When Oracle starts, it complains that this file is missing:
>
> ORA-01157: cannot identify data file 12 - file not found
> ORA-01110: data file 12 ' <path-to-file>.dbf '
>
> OK - fair enough, but...
>
> ...this seems to be preventing Oracle initialising properly, hence I
> cannot access other tablespaces. I cannot login to sqlplus as other
> users.
>
> Will dropping this user solve the problem? If so, can I do it using
> "svrmgrl"?
>
> Thanks,
> Joe
Received on Tue Jan 22 2002 - 10:41:36 CST