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

现象：GG做init data load时报错OGG-00869 OGG-001992013-11-11 15:54:18 INFO OGG-03501 Oracle GoldenGate Delivery for Oracl

现象：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导入表定义。

DeepSeek

幻方量化公司旗下的开源大模型平台

10435

查看详情