Re: Change oracle_sid in 9i ?

Help please!!!

I did going into a DOS prompt and do the following:

C:\set ORACLE_SID = DAVID
(My SID is DAVID)

I did not set ORACLE_HOME because 2 of my DATABASES is in the same box.

It still doesn't work and I don't have a clue.

David

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E57CCAF.4BE1B60C_at_exesolutions.com>...
> David Nguyen wrote:
>
> > No I never get any error message. I run my application it work fines
> > for both databases and I have 2 seperate services and 2 seperate
> > intances. I access database no problem both from client and server
> > thru ODBC
> > I'm also access both database no problem thru SQL application because
> > when I use SQL plus it ask for USERID/PASSWORD and string and the
> > string is the intance and I access both intances no problem
> >
> > To run exp/imp I have to run exp/imp ID/PASSWORD_at_intance it do work
> > for both database.
> >
> > However, if I click on EXP/IMP from BIN folder it doesn't give me a
> > choice to connect to an intance that I want but default to a second
> > database
> >
> > I know I need to change ORACLE_SID to a SID that I want
> >
> > But how to change a SID that's my question?
> >
> > Thanks
> >
> > David
> >
> > DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E56AB2A.238E19D5_at_exesolutions.com>...
> > > David Nguyen wrote:
> > >
> > > > Hi all,
> > > >
> > > > I created a second database in Oracle 9i windows 2000 (in the same
> > > > box). Now I try to run EXP/IMP and it keep EXP/IMP the data from my
> > > > second database. How can I switching back to EXP/IMP of my first
> > > > database.
> > > >
> > > > Panic ! please help
> > > >
> > > > David
> > > >
> > > > I'm appreciated if someone send a reply back to my email:
> > > > nguyend4_at_hotmail.com
> > >
> > > Read your post above. I've no doubt you are in a panic. But from what
> > > you wrote I can't figure out why? You wouldn't happen to have an
> > > ORA-##### message you're keeping secret would you?
> > >
> > > Did you reset ORACLE_SID? ORACLE_HOME?
> > >
> > > Daniel Morgan
>
> 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
Received on Mon Feb 24 2003 - 13:05:55 CST