When you do alter database open; what error do you get? Guillermo Alan Bort DBA / DBA Main Team EDS, an HP company ITO Arias 1851 Ciudad Autonoma de Buenos Aires (C1429DXC) Argentina Tel: +54 11 4704-3132 E-mail: guillermo.bort@xxxxxxx <mailto:name.name@xxxxxxx> We deliver on our commitments so you can deliver on yours. From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dba DBA Sent: Friday, December 19, 2008 3:25 PM To: Allen, Brandon; oracle-l@xxxxxxxxxxxxx Subject: Re: someone deleted my datafile doesn't work with the database not opened. I have it in mount state. On Fri, Dec 19, 2008 at 12:23 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote: I'm not sure if this is the right answer, but I think you might be able to take the missing datafile and/or tablespace offline first and then open the database. Did you try that? From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dba DBA Sent: Friday, December 19, 2008 10:18 AM To: oracle-l@xxxxxxxxxxxxx Subject: someone deleted my datafile I know this is a stupid question. I am mainly a developer. I do what is needed as a DBA sometimes. I am using google to solve this. I just needed my database to open. I don't care about losing the tablespace. On windows oracle 10.2 I just created the database. It is for development purposes. There is nothing in it I can't afford to lose. I don't have a backup. I just want to drop the tablespace with the datafile in it. 1. I can mount the database, but can't open it because oracle can't find the datafile 2. i cant drop the tablespace in mounted mode. I know there is a way to fix this. what do I do? I know I need to somehow drop the tablespace. ________________________________ Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.