Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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?

Re: When running multiple Oracle instance, how can I specify which database I would like to export/import?

From: Arne Sodal <apsodal_at_-NOSPAM-online.no>
Date: Mon, 05 Mar 2001 19:49:35 +0100
Message-ID: <3AA3DFBF.DEE20A49@-NOSPAM-online.no>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US