Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: howto drop a corrupt database ?
> >It is said that 10g will provide a drop database command. Though I'd believe that
> >the datafiles need to be OMF for oracle to clean up the datafiles also.
> >
> >Anurag
> >
> Why would they have to be OMF? Oracle has always been able to create
> OS files (CREATE TABLESPACE . . .), so why couldn't it delete them?
Probably the same reason a simple DROP TABLESPACE command can't delete the datafiles. For some reason (?) a simple DROP TABLESPACE won't delete the datafiles unless the files are OMF. There is a clause (INCLUDING CONTENTS AND DATAFILES) that will do it as well. Maybe DROP DATABASE in 10G has a similar clause.
Cheers,
Brian
-- =================================================================== 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 - 14:49:59 CST