Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: howto drop a corrupt database ?
From the most recent literature on OMF that I've seen from Oracle Corp,
OMF wasn't preached as a good idea for production databases, but rather
a good idea if you need to quickly and easily set up a simple database
for something like testing. This was even discussed in the Oracle
Education materials.
Cheers,
Brian
Daniel Morgan wrote:
>
> 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)
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Mon Nov 10 2003 - 16:14:44 CST