RE: Importing large tables on linux 8.1.7

Use named pipes..

export and import from the linux machine all in one step..

# ON LINUX MACHINE:

$ mkfifo namedpipe
$ exp userid=user/pass_at_nt_db parfile=nt_options.par file=namedpipe &
$ imp userid=user/pass parfile=linux_options.par file=namedpipe

Obviously the imp assumes your environment is set appropriately for the instance you want. Don't put an @linux_db to the connect for imp. It'll slow things down! Use the parfiles to suite. Now you've exported and imported in one step, without wasting disk space for the dmp file and eliminating the 2GB limitations.

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Rachid Moutawakkil [mailto:r.moutawakkil_at_sicodex.co.ma]
> Sent: Wednesday, December 13, 2000 3:37 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Importing large tables on linux 8.1.7
>
>
> Hi gurus,
>
> We are trying to migrate from nt to linux and encountered
> problems while
> exporting a large table >2Gb
> On technet discussions it seems an old extremely frustrating
> topic witch
> couldn't be resolved by oracle
> So the question to dbas: has any body an idea to overcome the
> problem, any
> suggestion will be very helpful.
>
> Thanks
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachid Moutawakkil
> INET: r.moutawakkil_at_sicodex.co.ma
>
> 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).
Received on Thu Dec 14 2000 - 13:57:18 CST