How does one change the SID of an existing databa
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Wed, 15 Jun 94 21:02:00 -0500
Message-ID: <12a.2692.905_at_compudata.com>
Date: Wed, 15 Jun 94 21:02:00 -0500
Message-ID: <12a.2692.905_at_compudata.com>
-> is the procedure to change the SID name of an instance, or is this
Under Oracle 6 or Oracle 7?
Under 6, IMPOSSIBLE (or real close). Easier to export, recreate, and import. It's not just in the DB, it's also embedded in the logs and control files.
Under 7, simple. Just recreate the control file(s) with the the alter sid syntax. Received on Thu Jun 16 1994 - 04:02:00 CEST