control file reuse [message #530546] |
Wed, 09 November 2011 01:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/368bf8a4d5b67943969dc72a4734adaa?s=64&d=mm&r=g) |
sanketa
Messages: 1 Registered: November 2011 Location: pune
|
Junior Member |
|
|
what is a use of command 'controlfile reuse at the time of database creation.
|
|
|
|
Re: control file reuse [message #530597 is a reply to message #530550] |
Wed, 09 November 2011 03:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
hi,
I think it just as when add a datafile into a tablespace,if the datafile exists in OS,it will raise a error,with the REUSE,it will overwrite the current datafile.
alter tablespace test
add datafile 'E:\mydb\df01.dbf' size 1g reuse
CM: Fixed code tags. End one needs a / at the start.
[Updated on: Wed, 09 November 2011 04:44] by Moderator Report message to a moderator
|
|
|
Re: control file reuse [message #530601 is a reply to message #530597] |
Wed, 09 November 2011 04:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68664 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
The question was about CONTROL file not DATA file (but the principle is the same one).
Follow the link John gave.
Regards
Michel
|
|
|