Re: Export and at the same time import via named pipe.

>Hi All,
>
>
>Someone mentioned to me today that it is possible do an export and pipe=
> the
>output to the oracle import utility to import the data into another
>database.
>Does anybody know if this is indeed possible and if so, how and what ar=
>e
>the things to be aware of?
>
>TIA
>
>Jack
>

mkfifo mypipe
(ORACLE_SID=source; export ORACLE_SID; exp system/manager file=mypipe blablah) & ORACLE_SID=target
export ORACLE_SID
imp system/manager file=mypipe full=y blahblah

If you understand how it works, well, nothing is much different from doing it in sequence (except the load for your machine ...). You can also use system/manager_at_source etc. if you do not want to toy with ORACLE_SID or if your databases are on different computers (and you have a a lot of bandwidth in between).
A bit like tar cvf - . | (cd elsewhere; tar xvf -), except that you have to explictly create the pipe.

Regards,

Stephane Faroult
Oriole Corporation

--
Diese E-Mail wurde mit http://de.mail-inspector.de verschickt
Mail Inspector ist ein kostenloser Service von http://www.is-fun.net

Der Absender dieser E-Mail hatte die IP: 195.25.229.12

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).