Changing ORACLE_SID
From: Jared P. Hecker <hecker_at_panix.com>
Date: 9 Apr 1994 20:50:19 -0400
Message-ID: <2o7igb$he_at_panix.com>
Date: 9 Apr 1994 20:50:19 -0400
Message-ID: <2o7igb$he_at_panix.com>
Meanwhile, in a space-time continuum unknown to Earth, bpearc1_at_tisdec.tis.tandy. wrote:
>
> instances. I know that this requires changing the ORACLE_SID, but
> I have not figured out an easy way to do this to allow toggling back
> and forth.
If you mean change your environmental variables, I use a shell script to do it.
If you mean change the instance ID, you have to create the new database; to do so requires, among other things, manually editing the initial control file to include the new SID.
hth -
jh
-- Jared Hecker hecker_at_panix.com 76276.740_at_compuserve.com X.400 one of these days... --- þ KWQ/2 1.2d NR þReceived on Sun Apr 10 1994 - 02:50:19 CEST