Oracle Goldengate 11g Complete Cookbook

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'); ...