Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Help - accidentally deleted tablespace file

Re: Help - accidentally deleted tablespace file

From: <zaq_at_abc.com>
Date: 16 Apr 2001 19:34:35 GMT
Message-ID: <9bfhgb$r03$1@news.netmar.com>

This is zaq - I found my own answer after doing a search using another web site search engine. It is in
comp.databases.oracle.server
2000-12-04
Subject: Re: Deleted .dbf file instead of drop tablespace ... I'll search harder before I post next time.

Zaq

In article <9bf8ft$ac6$1_at_news.netmar.com>, <zaq_at_abc.com> writes:
>
>
>I am running Oracle 8.0.5 on Solaris.
>I have a database with a number of tablespaces. In
>one tablespace which has just two indexes in it,
>I dropped the indexes, forgot to drop the tablespace,
>then did a (Unix) rm to remove the
>file that the tablespace was created with.
>Now, when I try to do a dbstart, I get errors
>ORA-01157: cannot identify data file 23 - data not found
>ORA-01110: data file 23: (path to the file I deleted)
>
>and I cannot get into sqlplus -
>
>ORA-01033: ORACLE intialization or shutdown in progress
>
>I can't restore the file from backup because I just created the
>tablespace today, and the backup job runs tonight.
>How do I undo my mess?
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web



> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
 groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
>made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Mon Apr 16 2001 - 14:34:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US