Re: Change oracle_sid in 9i ?

If go to the NT Command prompt (cmd.exe) you will be able to enter command line options.
If you are not sure what that is, then find a helpful NT expert to show you. They can set up a script (export_PROD.cmd) that contains all the command line options, then you can just click that to export from the safety of your Windows Desktop. Sigh.

Liggs

"David Nguyen" <nguyend4_at_hotmail.com> wrote in message news:9a0092d.0302211920.1657d514_at_posting.google.com...
> 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 Sat Feb 22 2003 - 09:54:21 CST