Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: howto drop a corrupt database ?
"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.
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