I'd see if i can do this in 4 steps
Step 1) on the target database, SQL> alter database backup control to trace;
Step 2) copy the trace file and modify to specify the new database name and the first line of the sql file and all lines after the create controlfile statement
CREATE CONTROLFILE REUSE SET DATABASE "NEWNAME" RESETLOGS
Step 3) Copy cold back datafiles minus temp file and control file.
Step 4) Make sure that the last 2 lines of the trace file is run
SQL> ALTER DATABASE OPEN RESETLOGS;
and also make sure that the temp tablespace is created which also happens to be the last line in the trace file
Here is a proper how-to link if my steps didn't make sense: http://www.oracle.com/technology/obe/paa/obe-mdb/html/DB_CPY.htm
Who wouldn't want to separate the traffic at home for security reasons. The more common ones include wireless guest and wireless users. ...
Broadlink now has quite a lot of integration options almost out of the box. If you enable Broadlink IHC, you can directly link it to Alexa b...
How to setup Fibaro home center lite (HCL) slider for virtual devices. As the Fibaro HCL does not support LUA. The question was how to upd...
I spoke too soon, just as I was commenting on how stable Windows XP was in Apple is Evil , Windows XP decided to go blue screen on me. At th...