Re: howto drop a corrupt database ?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 10 Nov 2003 20:56:55 GMT
Message-ID: <rYSrb.9936$hB5.6433@nwrdny02.gnilink.net>

  "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1068497042.864793_at_yasure...   Anurag Varma wrote:

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:jsdvqv05do7g29sltb2ipjilnhu8too9jt_at_4ax.com...   On Sun, 09 Nov 2003 20:22:18 GMT, "Anurag Varma" <avdbi_at_hotmail.com> wrote:

    "DJ" <nospamplease_at_goaway.com> wrote in message news:Afxrb.1355$Tc2.9439_at_newsfep4-glfd.server.ntli.net...

      --snip-
      It's kind of sad, with all the advanced features, Oracle failed to provide
          a
        "drop database" command until now.


          im kind ain two minds about that.  i could imagine a situation where someone

does drop database and everything goes and they didnt mean to whereas havign to physically delete files is a clear intent of wanting to get rid of it.

But thrn again, if I do wanna remove a database, i dont like having to faff around deleting every single file associated with it

        It is said that 10g will provide a drop database command. Though I'd believe that the datafiles need to be OMF for oracle to clean up the datafiles also.

Anurag

      Why would they have to be OMF? Oracle has always been able to create OS files (CREATE TABLESPACE . . .), so why couldn't it delete them?     

Ed,

I don't know .. I don't have access to 10G.

So :) I'm in no position to debate about this.

Anurag
  Well I do have 10g. And since I have no idea what OMF stands for that may well answer the question.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply):) Thanks for the clarification. OMF stands for Oracle Managed Files.http://otn.oracle.com/products/oracle9i/daily/04.htmlAnurag

Received on Mon Nov 10 2003 - 14:56:55 CST