| control file reuse [message #530546] |
Wed, 09 November 2011 01:15  |
 |
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  |
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 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
