GG做init data load时报错OGG-00869 OGG-00199 解决

现象：GG做init data load时报错OGG-00869 OGG-00199
2013-11-11 15:54:18 INFO OGG-03501 Oracle GoldenGate Delivery for Oracle, initrep.prm: WARNING: NLS_LANG environment variable is invalid or not set. Using operating system character set value of AL32UTF8.
2013-11-11 15:54:18 INFO OGG-01236 Oracle GoldenGate Delivery for Oracle, initrep.prm: Trace file /tmp/s.out opened.
2013-11-11 15:54:19 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, initrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap（MAP_ANON） anon free: munmap
file alloc: mmap（MAP_SHARED） file free: munmap
target directories:
/home/oracle/ogg/dirtmp.
2013-11-11 15:54:19 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, initrep.prm: REPLICAT INITREP started.
2013-11-11 15:54:19 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, initrep.prm: Failed to retrieve column list handle for table SYMICS.A.
2013-11-11 15:54:19 ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, initrep.prm: Table SYMICS.A does not exist in target database.
2013-11-11 15:54:24 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, initrep.prm: PROCESS ABENDING.
2013-11-11 15:54:24 INFO OGG-01237 Oracle GoldenGate Delivery for Oracle, initrep.prm: Trace file /tmp/s.out closed.分析：
TARGET端只建立了数据库账号，没有创建相关表，如下：
SQL> describe SYMICS.A
ERROR:
ORA-04043: object SYMICS.A does not exist
对于init data load时，需要先在目标端将source的表创建好，否则会报错。解决方法：
init data load前，先通过exp/imp导入表定义。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12OGG执行DDL复制报ORA-01435 user does not existGG做init data load时，报错OGG-01192，OGG-01668相关资讯 OGG-00869 OGG-00199 本文评论查看全部评论（0）