Home » RDBMS Server » Server Administration » control file reuse (oracle 10g red hat 6)
control file reuse [message #530546] Wed, 09 November 2011 01:15 Go to next message
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 #530550 is a reply to message #530546] Wed, 09 November 2011 01:35 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Are you familiar with the Oracle documentation? This link
http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/statements_5003.htm#i2061000
takes you to the description of the CREATE CONTROLFILE command, which includes the meaning of REUSE.
Re: control file reuse [message #530597 is a reply to message #530550] Wed, 09 November 2011 03:59 Go to previous messageGo to next message
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
Michel Cadot
Messages: 59122
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
Previous Topic: exchange partition with update indexes issue
Next Topic: how to find unused columns
Goto Forum:
  


Current Time: Thu Sep 18 02:45:38 CDT 2014

Total time taken to generate the page: 0.10450 seconds