Re: Datapump question
From: Madhu Sreeram <madhusreeram_at_gmail.com>
Date: Wed, 21 Dec 2011 15:47:54 -0600
Message-ID: <CAPZqL6GLB0gZyERfBJd_SaTRadoQDN-jc8C0_mi71btFx97fSQ_at_mail.gmail.com>
The scn parameter is designed to get a consistent export (kind of a snapshot of data at a particular time). If your intention is to get the "delta" export, that is, rows changed after a particular SCN, then the answer is no. You will have to use some kind of replication to achieve what you need. For replication, checkout Materialized views, or streams or goldengate.
Date: Wed, 21 Dec 2011 15:47:54 -0600
Message-ID: <CAPZqL6GLB0gZyERfBJd_SaTRadoQDN-jc8C0_mi71btFx97fSQ_at_mail.gmail.com>
The scn parameter is designed to get a consistent export (kind of a snapshot of data at a particular time). If your intention is to get the "delta" export, that is, rows changed after a particular SCN, then the answer is no. You will have to use some kind of replication to achieve what you need. For replication, checkout Materialized views, or streams or goldengate.
-Madhu Sreeram
On Tue, Dec 20, 2011 at 4:08 PM, CRISLER, JON A <JC1706_at_att.com> wrote:
> I need to migrate a database from 11.1 non-RAC to 11.2 RAC. Does Datapump expdp and impdp support a method where I can export a full backup, then do later exports based on SCN number, and also import those same files into the target db ? I want to do the final cutover in a short period of time. Due to the location of the systems (and version mismatches) Dataguard is not feasible, and due to the version differences I would prefer to stay away from RMAN. The database is actually fairly small.
>
> I see the flashback_scn parameters but I am not clear if that is what I need.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 21 2011 - 15:47:54 CST