Re: someone deleted my datafile
- From: "Dba DBA" <oracledbaquestions@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 19 Dec 2008 12:24:46 -0500
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.
>
Other related posts: