Changing DBID

Giganews Newsgroups
Subject: Changing DBID
Posted by:  Chuck (chuckh1958_nospam@gmail.com)
Date: Tue, 08 Jul 2008

Is there a way to reset the DBID of a database to a specific value? For
example in the case if a duplicated database, I want to reset the DBID
of the auxiliary DB to it's original DBID after the duplication is
complete to make maintenance on the old backups easier. The auxiliary
database in question is a test db, is not in archivelog mode, and all
it's backups are cold backups.

TIA

Replies