How to Rename Oracle Database Using NID command Line Utility

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Requirement is rename the database name from SOURCE to TARGET

Steps:
  1. Create the initTARGET.ora file with necessary parameters. Db_name parameter value must be TARGET.
  2. Shutdown the SOURCE database
export ORACLE_SID=SOURCE
SQL> shutdown immediate;
  1. Startup mount the TARGET database using initTARGET.ora parameter file.
  2. Run the nid command in the command prompt.
nid TARGET=SYS/syspassword  DBNAME=TARGET SETNAME=YES

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer