Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Copying a Database

Copying a Database

From: KWIATKOWSKI LARRY <KWIATKOWSKIL_at_SICDES.DNET.ETN.COM>
Date: 1997/02/28
Message-ID: <3316F914.44D1@SICDES.DNET.ETN.COM>#1/1

I want to rename a database and instance from EDUC to DEVL. Is this the correct procedure:

  1. start the database in mount mode
  2. rename the datafiles "/id01/EDUC/control01" "/id01/DEVL/control01" (rename all datafiles to the new DEVl name)
  3. stop the instance.
  4. change oratab from EDUC to DEVL.
  5. copy the ofa compliant directories EDUC to DEVL.
  6. edit the init.ora files to reflect the new controlfilenames.
  7. start the new instance.

any input will be appreciated Received on Fri Feb 28 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US