change database id of database

SQL script to change database id of database.

shutdown immediate
startup mount
host nid target=/
connect / as sysdba
startup mount
alter database open resetlogs;

Leave a Reply

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>