Loading data with the GoldenGate direct load method

In this recipe we will look at how to perform an initial load using the GoldenGate direct load method.

Getting ready

For this recipe we will use the following setup:

  1. Create a modified version of the EMP table that is delivered in the SCOTT demo schema with Oracle binaries in the source and target databases. You can use the following DDL statement to create the EMP table:
    CREATE TABLE EMP (
    EMPNO NUMBER(10) PRIMARY KEY, 
    ENAME VARCHAR2(25),
    JOB VARCHAR2(25),
    MGR NUMBER(10),
    HIREDATE DATE,
    SAL NUMBER(20,2),
    COMM NUMBER(20,2),
    DEPTNO NUMBER(10),
    CITY VARCHAR2(25));
    
  2. Use the following script to load 1 million rows into this table:
    BEGIN 
    FOR I IN 1..250000 LOOP
    INSERT INTO EMP VALUES (0+I,'TOM'||I,'WORKER',7369,TO_DATE('07-11-2012','DD-MM-YYYY'),10000+I,I,10,'LONDON'); ...

Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.