DataPump

Import order matters for GoldenGate instantiation filtering

When migrating a large database with GoldenGate, most of the volume is sometimes in old partitions which no longer change. A common shortcut is to move them first with expdp/impdp, even before GoldenGate is set up. Everything else, the(…)

Removing instantiation filtering from a GoldenGate replicat

In a recent blog, I explained how instantiation filtering works. DBOPTIONS ENABLE_INSTANTIATION_FILTERING makes a replicat discard any record whose commit CSN is at or below a table’s instantiation CSN. It applies everything above it. This(…)

GoldenGate instantiation CSN explained

For more than ten years (GoldenGate 12.2, released in 2015), GoldenGate has provided a way of performing initial load of tables with a per-table instantiation CSN. But when migrating a database or just performing the initial load of(…)

Migrate your database to 26ai on ODA

Introduction Oracle 26ai is not yet available on Bare Metal ODA, but it will probably be in a few weeks. For now, 26ai is available as a DB System on Oracle Database Appliance, meaning that it’s already possible to(…)

DataPump and the Transform option – Not very well known, but it can be useful

I work with Oracle Databases and Datapump for more than 10 years but still I find some datapump options that I did know and in some cases can be very helpful. For a customer we did a migration of(…)

DataPump ‘Processing object type’ misleading messages

By Franck Pachot . You've started a long DataPump and see it stuck on TABLE/STATISTICS/TABLE_STATISTICS, but you don't expect that step to take a long time. Let's see if we can rely on that message.