RE: expdp using mknod

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <satheeshbabu.s@xxxxxxxxx>
  • Date: Fri, 3 Feb 2006 20:08:13 +0100

Satheesh

> i wanted to take the compressed export using expdp. Which we do similar for 
> export

Similar doesn't mean same...

>Like,
> mknod exp_pipe p
> gzip < exp_pipe > stgdb1.exp.gz &
> expdp username/pwd DUMPFILE=exp_pipe DIRECTORY=tmpdmp full=y 
> logfile=entire.log

You have two problems here:

1) Data Pump doesn't write data sequentially in the dump file. Therefore pipes, 
tapes, ... are not supported.

2) Data Pump doesn't overwrite an existing dump file.


HTH
Chris
--
//www.freelists.org/webpage/oracle-l


Other related posts: