Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: howto drop a corrupt database ?
Howard J. Rogers wrote:
>"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
>
>
Maybe my mind recoiled in such horror I forgot. But then again maybe it
means I have
been getting out.
If this is someone's idea of making Oracle as easy to manage as SQL
Server I hope
they are someday forced to leave their marketing job and get a job in
the real-world.
In 9i there was nothing wrong with drop tablespace including datafiles
... this is another
piece I need to add to my 10g curriculum with the caveat ... you can do
it ... but don't.
Note to Mr. Townsend: Surely this is just a bad joke.
-- 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)Received on Mon Nov 10 2003 - 15:51:11 CST