RE: someone deleted my datafile

Alter tablespace TBS offline;

Alter database open;

Drop tablespace TBS;

 

Should do the tric. Incidentaly, what is the tablespace? If it is either
undo or system then you are screwed... otherwise should be recoverable.

 

hth

 

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:18 PM
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.

Other related posts: