Re: Change oracle_sid in 9i ?

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
Received on Fri Feb 21 2003 - 21:20:29 CST