Re: File write error on pipe export

"Alex" <avilner_at_gmail.com> ha scritto nel messaggio news:1137041384.675270.105290_at_g49g2000cwa.googlegroups.com...
> Dear netters,
>
> We are trying to build a piped export/import of specific tables on
> Oracle 10g (AIX).

What do you mean by "piped"? You have to do "something" with the "data" that passes through the named pipe.
If you want to run the export and compress utilities simultaneously, then (quoted from orafaq):

 # Make a pipe
 mknod expdat.dmp p # or mkfifo pipe  # Start compress sucking on the pipe in background  compress < expdat.dmp > expdat.dmp.Z &
 # Wait a second or two before kicking off the export  sleep 5
 # Start the export
 exp scott/tiger file=expdat.dmp

Or export accross the network directly into the target database:

 Host A:
 mknod FIFO.dmp p
 exp u/p FILE=FIFO.dmp rest_of_parameters...

 Host B:
 mknod FIFO2.dmp p
 rsh host1 dd if=FIFO.dmp > FIFO2.dmp &
 imp u/p FILE=FIFO2.dmp rest_of_parameters...

Cheers,
DR Received on Thu Jan 12 2006 - 09:12:19 CST