Re: Datapump question

From: Madhu Sreeram <>
Date: Wed, 21 Dec 2011 15:47:54 -0600
Message-ID: <>

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 <> 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.
> --

Received on Wed Dec 21 2011 - 15:47:54 CST

Original text of this message