Re: Data Migration options - oracle to oracle

From: Karth Panchan <>
Date: Thu, 5 Sep 2013 06:53:23 -0400
Message-Id: <>


Sorry for blank mail earlier. Hit send by accident.

Need your suggestion to migrate data from oracle to oracle db instance for OLTP application.

  1. This migration need 50% table data transformation from source db to target db
  2. Need to do migration with index/constraints/triggers enabled on Target OLTP instance during other users using this instance at production mode.

Recommended GoldenGate and Streams at my place. There is a lack of knowledge and no one want take risk.

Written db package solution uses dblink for data migration using metadata.

I have been told running SQL Plus using dblink is much faster then DB package. Waiting for benchmark.

Anyone migrated data to live OLTP instance with index/triggers/constraints enabled in Oracle tools

Appreciate your help


On Sep 5, 2013, at 6:29 AM, Karth Panchan <> wrote:


Received on Thu Sep 05 2013 - 12:53:23 CEST

Original text of this message