Changing Oracle Database ID and Name (nid)
Getting back into Oracle as a DBA I've been reading up and watching tutorials to try to get the old skills back and update to the new tools, last time I DBAed in anger we were still on Oracle 7 and 8i, 9i had been out a while and 10g was in early versions, but because much of our software was so old we weren't using it much. I came across a tutorial on how to update the name and ID of a database. This is useful if you have copied a database and want to rename the copy to stop it being confused with the old, or if you want to have it on the same machine as the old. The database ID is an internal number used by Oracle to identify the database, it looks like the main reason you'd want to change the ID is if you use RMAN and want to have both in the same repository. PLEASE NOTE: The below is based on a tutorial I watched and has not been tested, errors and omissions are expected. Before using in production do a few practice runs on sandbox databases. Proc...