Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: When running multiple Oracle instance, how can I specify which database I would like to export/import?
Like you do on Unix: Set the "ORACLE_SID as a parameter before you do the export, eg. 'set ORACLE_SID=<sid_name>'.
Arne S
AndreaG wrote:
> Configure your TNSnames.ora file (use SQL net easy configuration) and then
> specify
> user/pwd_at_inst_name in your exp/imp command line.
>
> "Tim Lee" <timothy.yw.lee_at_philips.com> wrote in message
> news:97vmbg$ntp7_at_imsp212.netvigator.com...
> > Dear all:
> >
> > I have multiple instances on my Oracle Server running NT 4.0. When I do
Full
> > Database Export/Import, how can I specify which database I would like to
> > export/import?
> >
> >
Received on Mon Mar 05 2001 - 12:49:35 CST
![]() |
![]() |