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 -> Need Help Moving A Database

Need Help Moving A Database

From: Madhu Cherukuri <madhu.cherukuri_at_usa.net>
Date: Tue, 10 Nov 1998 06:56:34 -0800
Message-ID: <CuY12.1672$C5.3571013@WReNphoon1>


Hi,

Here are the steps for relocating the datafiles.

  1. Mount the database (but not Open)
  2. Copy the datafiles to be renamed to their new locations and new names, using OS commands
  3. Use the SQL command ALTER DATABASE to rename the file pointers in the database's Control File
  4. Open the database with ALTER DATABASE OPEN

You should not edit the Control file

The above steps will automatically change the file names and paths in the control file to reflect the new location.

After opening the database, the relocated datafiles will be accessed by the contolfile

HTH Madhu Cherukuri

   -**** Posted from Supernews, Discussions Start Here(tm) ****- http://www.supernews.com/ - Host to the the World's Discussions & Usenet Received on Tue Nov 10 1998 - 08:56:34 CST

Original text of this message

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