Re: Change oracle_sid in 9i ?

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 Sat Feb 22 2003 - 13:17:03 CST