I have seen this example using reuse set in a lot or oracle documentation.
I have always used set and not reuse set so I was wondering what the
difference was.
Thanks.
Dustin


-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x15326703.[Email address protected]
Sent: Tuesday, November 01, 2005 12:32 PM
To: LazyDBA Discussion
Subject: RE: set and reuse set

The second line is not correct. You can either use "set" or "reuse" command.
You use set command whenever you want to change the database name and
"reuse" command when you want to maintain the existing database name.

Whenever, you would use set command you will need to use resetlogs
invariably because you want the logs to start from 1 again.

Nooarchivelog is simply to tell the control file that you are initially
opening database in noarchivelog mode.


Gurmohan
www.onlymath.com - Place to learn and teach math.





-----Original Message-----
From: Dustin Hayden
[mailto:oracledba-ezmlmshield-x52229852.[Email address protected]
Sent: Tuesday, November 01, 2005 12:22 PM
To: LazyDBA Discussion
Subject: set and reuse set


Can someone please explain the difference between the using the following?



Create control file set database "NAME" resetlogs noarchive log

And

Create control file reuse set database "NAME" resetlogs noarchive log





TIA

Dustin





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page