Oracle NID utility NID is utility to change the database name and/or database id. Usage. 1) Backup the database 4) Here you use the NID utility, through command execute the following nid target=sys/<password>@<old_database> dbname=<new_database_name> For example set oracle_sid=philips After these modification will be made to control file and datafile Now shut the database Now we need to change the db_name in the pfile or spfile
If required modify the service id (in windows) SQL>alter database open resetlogs;
|
Database Technologies > Oracle >