GoldenGate Oracle to MSSQL Server - Initial Table Create
Date: Tue, 29 Mar 2022 16:26:37 +0200 (CEST)
Message-ID: <992356481.19574.1648563997465.JavaMail.zimbra_at_performing-db.com>
Hi listers,
currently I try to build a "simple" one-way GoldenGate 21c replication of a whole, self-contained Oracle-schema to a database on MS SQL Server. So far, I think I got the idea how to build the instantiation- and replication EXTRACTs and REPLICATs, and I can start them w/o errors and all.
BUT: How do I get GG to CREATE the actual tables in the target database? All I get during instantiation is
EXTRACT:
REPLICAT:
That, in fact, is true, but how do I get them there? I can't honestly extract, translate and create thousands of tables manually to SQL Server...
INFO OGG-00993 Oracle GoldenGate Capture for Oracle, initex.prm: Extract group EXTRACT INITEX started.
INFO OGG-02911 Oracle GoldenGate Capture for Oracle, initex.prm: Processing table MYSCHEMA.MYTABLE.
WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, initex.prm: Extract task INITRP abended : Initial data load error reported by REPLICAT.
ERROR OGG-01203 Oracle GoldenGate Capture for Oracle, initex.prm: Extract abending.
WARNING OGG-00869 Oracle GoldenGate Delivery for SQL Server: Could not retrieve definition for table dbo.MYTABLE.
ERROR OGG-00199 Oracle GoldenGate Delivery for SQL Server: Table dbo. MYTABLE does not exist in target database.
ERROR OGG-01668 Oracle GoldenGate Delivery for SQL Server: PROCESS ABENDING.
Thank you for your ideas!
--
Martin Klier // Performing Databases GmbH
Managing Partner // Senior DB Consultant
martin.klier_at_performing-db.com // https://www.performing-databases.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 29 2022 - 16:26:37 CEST