Re: CONTROLFILE_REUSE

The REUSE option specifies that existing control files identified by the initialization paramter CONTROL_FILES can be resued, thus ignoring and overrwriting any and all information they may currently contain. If you omit this option and any of these control files already exist, ORACLE returns error

hope that helps
wozi_at_dhc.net

Jonathan Gennick wrote in message
<374a8014.20096645_at_netnews.worldnet.att.net>...
>I'm wondering if anyone can provide some reasons to use the
>CONTROLFILE_REUSE clause of the CREATE DATABASE statement?
>Someone recently asked me about this, and I have no idea
>what answer to give. I never use it. I just delete the old
>control files an recreate them. I know what the clause does,
>but given the relatively small size of control files
>relative to other database files, I don't know what I would
>gain from using it. Any insights?
>
>Jonathan
>
>_____________________________________________________
>jonathan_at_gennick.com
>http://gennick.com
>Brighten the Corner Where You Are
>
Received on Mon May 24 1999 - 13:48:17 CDT