How to Rename Oracle 11g 10g Database Using NID command Line Utility

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google