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

From: some joe <hartj_at_logica.com>
Date: 22 Jan 2002 08:36:24 -0800
Message-ID: <454f97e7.0201220836.77e9e910@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:36:24 CST