Archive

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(…)

GoldenGate 26ai AutoSchema TYPEMAP: overriding the default datatype mapping

In my blog about the new automatic schema evolution feature in GoldenGate 26ai, I was replicating the following table from Oracle to PostgreSQL: CREATE TABLE autosch.t1 ( id NUMBER PRIMARY KEY, name VARCHAR2(50), amount NUMBER(10,2),(…)

GoldenGate 26ai automatic schema evolution: creating missing tables during an initial load

For as long as I have used GoldenGate, an initial load had one prerequisite: the target tables must already exist. Data Pump takes care of it between two Oracle databases. For anything else, you write the CREATE TABLE statements(…)