Re: howto drop a corrupt database ?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 11 Nov 2003 07:55:32 +1100
Message-ID: <3faffb56$0$9225$afc38c87@news.optusnet.com.au>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in bloody HTML again:

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

---

Well, you need to get out more, Daniel, and do some reading.

Oracle Managed Files.

A short name for an appalling 9i new feature, whereby you can say 'create tablespace X', and that's it. No need to mention a datafile clause, because db_create_file_dest as an init.ora parameter tells the system where to stick 'em. No need to specify a size, because you'll get 100MB by default. Oh, and they will be autoextend on, with no maxsize set, and no next clause either. Possibly the worst combination of performance defaults they could have come up with.

You can do the same for redo logs, too (they aren't autoextend, obviously, but they are 100MB by default).

Oh, and that means you can now actually type 'create database blah', semi-colon, and have done.

And it means that when you say 'drop tablespace X' or 'drop logfile group Y', Oracle will delete the relevant files off disk for you.

It was crap in 9i because of the dreadful defaults, but they obviously invented it as a bridge to the new automated storage mechanisms in 10g.

Regards
HJR Received on Mon Nov 10 2003 - 14:55:32 CST