Database migration options
From: Chen Zhou <oracle.unknowns_at_gmail.com>
Date: Wed, 21 Mar 2018 17:50:26 -0700
Message-ID: <CAJUY3dS3owoPFhc9yZHjKHYN5j7k5VTQSHyhj+9AuVVXfaef5A_at_mail.gmail.com>
Hi,
Our company needs to migrate some databases to new servers. However we don't want to migrate the whole databases, which have years of old data. Rather, we want to select some newer data from some tables and only carry these over to the new databases. Export and import will take too long due to the large sizes of our databases.
Physical Standby won't work. Is logical standby an option here? I am also considering using GoldenGate.
Are there other options?
Thank you,
Chen
Date: Wed, 21 Mar 2018 17:50:26 -0700
Message-ID: <CAJUY3dS3owoPFhc9yZHjKHYN5j7k5VTQSHyhj+9AuVVXfaef5A_at_mail.gmail.com>
Hi,
Our company needs to migrate some databases to new servers. However we don't want to migrate the whole databases, which have years of old data. Rather, we want to select some newer data from some tables and only carry these over to the new databases. Export and import will take too long due to the large sizes of our databases.
Physical Standby won't work. Is logical standby an option here? I am also considering using GoldenGate.
Are there other options?
Thank you,
Chen
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 22 2018 - 01:50:26 CET