Re: someone deleted my datafile

you can't take the tablespace offline when the database is not open. I had to take the datafile offline.

open the database

drop the tablespace including contents and datafiles.

fixed.

On Fri, Dec 19, 2008 at 12:24 PM, Bort, Guillermo <guillermo.bort_at_eds.com>wrote:

> 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_at_eds.com <name.name_at_eds.com>
>
>
>
> We deliver on our commitments
>
> so you can deliver on yours.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Dba DBA
> *Sent:* Friday, December 19, 2008 3:18 PM
>
> *To:* oracle-l_at_freelists.org
> *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.
>

--
http://www.freelists.org/webpage/oracle-l