RE: Data Pump and compress on the fly in Unix
- From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
- To: "rjamya" <rjamya@xxxxxxxxx>
- Date: Wed, 10 Jan 2007 09:22:17 +1100
So how are you guys dealing with this problem then? The mknod allowed us
to export huge databases without needing the space up-front. Is there
anyone using DATA PUMP for real backups of large datababases? Or just
experimenting with it?
I realise that there's a COMPRESS=METADATA_ONLY option but this is just
the METADATA, not the huge amounts of application data that we have in
the database.
Oracle has told us to use datapump in 10g rather than exports. Now I
have a problem - BAM uses floating data types that is not supported with
exp but is supported with expdp. However, expdp does not allow
compression on the fly. I'm stuck. I can't possibly convert to data pump
given the lack of space available to perform the expdp.
________________________________
From: rjamya [mailto:rjamya@xxxxxxxxx]
Sent: Tuesday, 9 January 2007 10:50 PM
To: Leng Kaing
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Data Pump and compress on the fly in Unix
no, and it is not supported even in 10203, Larry knows that would happen
in 11.
rjamya
On 1/9/07, Leng Kaing < Leng.Kaing@xxxxxxxxxxx
<mailto:Leng.Kaing@xxxxxxxxxxx> > wrote:
I think the question has been asked before but I'm hoping that 10.2.0.3
has changed things - can we do a compress on the fly with expdb now? Ie.
using mknod. Has anyone managed to get this to work?
Other related posts:
