Re: Change oracle_sid in 9i ?

From: Claude PRAT <c.prat_at_qualiac.com>
Date: 23 Feb 2003 07:34:19 -0800
Message-ID: <8836e34f.0302230734.7fcc16ee@posting.google.com>

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E57CCAF.4BE1B60C_at_exesolutions.com>...

>
> Never forget that Windows is just a GUI shell still running on DOS. So run EXP and IMP from the DOS
> command line as Liggs says. To alter the environment variables just:
>
> SET ORACLE_SID=
> SET ORACLE_HOME=
>
> and provide the appropriate values.
>
> Daniel Morgan

Hi David,

Other environment variable to take care : LOCAL
this one is equality from TWO_TASK variable in Unix systems. It contains SQL*Net connect string stored in your tnsnames.ora. Of course, if you have diferant OA between your 2 instances : change it according to your version.
Hope it helps you. Received on Sun Feb 23 2003 - 09:34:19 CST