<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3132" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=413363515-15082007><FONT face="Courier New" size=2>Hello
All,</FONT></SPAN></DIV>
<DIV><SPAN class=413363515-15082007><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=413363515-15082007><FONT face="Courier New" size=2>I am trying
to get a large dataset from one database (Netezza) to another database
(Oracle). In Netezza, you can dump a large table within a couple of
minutes into a text file or a named pipe. As everyone knows, sqlldr does a
great job loading as well. So my thought is to have Netezza dump to a
named pipe and have Oracle SQL load from a named pipe. The problem I am
having is that these two databases are on different servers (Linux and
Solaris). Named pipes can not be use on NFS mounted file systems so I am
planning to use "ftp" a the conduit between the two pipes. Does anyone
know if that is possible? Or is there a better
solution?</FONT></SPAN></DIV>
<DIV><SPAN class=413363515-15082007><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=413363515-15082007><FONT face="Courier New"
size=2>Thanks.</FONT></SPAN></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV align=left><FONT face="Courier New" size=2>Peter</FONT></DIV></BODY></HTML>