Re: howto drop a corrupt database ?

Brian Peasland wrote:

>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
>>

Still ... we both know ... that it will be like the CONNECT, RESOURCE, and DBA roles.
They will be used ... because they are there.

-- 
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)