Re: EXTERNAL: Re: Datapump export, incremential only?

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 16 Aug 2011 18:20:54 -0400
Message-ID: <CAGurbTM8aXRhuTpTXiEdp+hHCT8P1Mdq9rodM3c6PUb+CRSN3A_at_mail.gmail.com>

No, just pure where clause applicable to a bunch of tables ... not via dba_tab_modifications ... however i see this could get difficult via expdp interface. However it might be possible to do this via dbms_datapump since it provides much more flexibility.

Raj

On Tue, Aug 16, 2011 at 2:50 PM, Grabowy, Chris <chris.grabowy_at_lmco.com>wrote:

> > I believe the DBA was trying to take advantage of that WHERE clause but
> was not able to make it work that way.
>
> Trying to use the WHERE clause to also query DBA_TAB_MODIFICIATIONS to
> retrieve a list of tables that have been updated recently. Simulating an
> incremental datapump export.
>
> You where able to do that?
>
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of rjamya
> Sent: Tuesday, August 16, 2011 1:39 PM
> To: Grabowy, Chris
> Cc: oracle-l_at_freelists.org
> Subject: Re: EXTERNAL: Re: Datapump export, incremential only?
>
> Interesting ... could/would you explain what problems were encountered? i
> am curious ... i have had success with it, but in my case list of tables
> against which the expdp was run was pretty short (< 10).
>
> Raj
> On Mon, Aug 15, 2011 at 8:37 PM, Grabowy, Chris <chris.grabowy_at_lmco.com>
> wrote:
> Gus,
>
> I believe the DBA was trying to take advantage of that WHERE clause but was
> not able to make it work that way.
>
>

-- 
-----
Best regards
Raj

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 16 2011 - 17:20:54 CDT