CREATE CONTROLFILE REUSE DATABASE OR SET DATABASE
Hi Guys,
I'm doing a db migration from one mount point to another mount point in the same server.
The location of controlfile, log files and datafiles will be change.
I have updated the new controfile location in my pfile and startup nomount.
When creating the controfile to reflect the new location of redo logs / datafiles, should i use "reuse" or "set" syntax? Can explain what's the diff between the 2? Have read up the document but not able to understand.
thanks