Re: What's the fastest ?

"Jérôme VUIBERT" <jerome.vuibert_at_fleximage.fr> wrote in message news:3efa986b$0$11550$626a54ce_at_news.free.fr...
> In fact the datafile sizes is about 20Go.
>
> But in order to make efficient export, I will do several exports. So the
> biggest dump file will not be 20Go.
>
> Is there only on local export that the compress option can be used ? I
> didn't know that !

Brian's suggestion wasn't in fact to use the compress option (which rejigs storage clauses on the object creation statements in the file) but to export the file to disk and then use a file compression utility on the resultant file. This is probably the most straightforward but IIRC it is possible with the neat use of redirecting output through a named pipe to compress on the fly and possibly then pass the stream of compressed data out via FTP something like (in flow diagram mode)

exp blah > named pipe < ftp to destination.

I wouldn't encourage this as it seems overly complex.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK