>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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
