ogg_Fatal error executing DDL

    2015-01-21 11:08:33  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is alrea

dy used by an existing object SQL CREATE TABLE "SCOTT"."SYS_EXPORT_SCHEMA_01" (process_order NUMBER, duplicate NUMBER, dump_file

id NUMBER, dump_position NUMBER, dump_length NUMBER, dump_orig_length NUMBER, dump_allocation NUMBER, completed_rows NUMBER, err

or_count NUMBER, elapsed_time NUMBER, object_type_path VARCHAR2(200), object_path_seqno NUMBER, object_type VARCHAR2(30), in_pro

gress CHAR(1), object_name VARCHAR2(500), object_long_name VARCHAR2(4000), object_schema VARCHAR2(30), original_object_schema VA

RCHAR2(30), original_object_name VARCHAR2(4000), partition_name VARCHAR2(30), subpartition_name VARCHAR2(30), dataobj_num NUMBER

, flags NUMBER, property NUMBER, trigflag NUMBER, creation_level NUMBER, completion_time DATE, object_tablespace VARCHAR2(30), s

ize_estimate NUMBER, object_row NUMBER, processing_state CHAR(1), processing_status CHAR(1), base_process_order NUMBER, base_obj

ect_type VARCHAR2(30), base_object_name VARCHAR2(30), base_object_schema VARCHAR2(30), ancestor_process_order NUMBER, domain_pro

cess_order NUMBER, parallelization NUMBER, unload_method NUMBER, load_method NUMBER, granules NUMBER, scn NUMBER, grantor VARCHA

R2(30), xml_clob CLOB, parent_process_order NUMBER, name VARCHAR2(30), value_t VARCHAR2(4000), value_n NUMBER, is_default NUMBER

, file_type NUMBER, user_directory VARCHAR2(4000), user_file_name VARCHAR2(4000), file_name VARCHAR2(4000), extend_size NUMBER,

file_max_size NUMBER, process_name VARCHAR2(30), last_update DATE, work_item VARCHAR2(30), object_number NUMBER, completed_bytes

 NUMBER, total_bytes NUMBER, metadata_io NUMBER, data_io NUMBER, cumulative_time NUMBER, packet_number NUMBER, instance_id NUMBE

R, old_value VARCHAR2(4000), seed NUMBER, last_file NUMBER, user_name VARCHAR2(30), operation VARCHAR2(30), job_mode VARCHAR2(30

), queue_tabnum NUMBER, control_queue VARCHAR2(30), status_queue VARCHAR2(30), remote_link VARCHAR2(4000), version NUMBER, job_v

ersion VARCHAR2(30), db_version VARCHAR2(30), timezone VARCHAR2(64), state VARCHAR2(30), phase NUMBER, guid RAW(16), start_time

DATE, block_size NUMBER, metadata_buffer_size NUMBER, data_buffer_size NUMBER, degree NUMBER, platform VARCHAR2(101), abort_step

 NUMBER, instance VARCHAR2(60), cluster_ok NUMBER, service_name VARCHAR2(100), object_int_oid VARCHAR2(32)) SEGMENT CREATION IMM

EDIATE INITRANS 10  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

目标数据库错误：

2011-02-28 14:19:39  ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  Fatal error executing DDL replication: error [Error code [1435], ORA-01435: ?????, SQL ALTER SESSION SET CURRENT_SCHEMA=SWASBHOM ], no error handler present.

2011-02-28 14:19:39  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  PROCESS ABENDING.

 

解决：

在复制进程脚本加上

DDL INCLUDE MAPPED

DDLERROR DEFAULT IGNORE RETRYOP

 

把进程修改成如下格式：

REPLICAT roraBB

userid userid  gg,password gg

HANDLECOLLISIONS

ASSUMETARGETDEFS

DISCARDFILE ./dirrpt/roraBB.DSC, PURGE,MAXBYTES 50000000

DDL INCLUDE MAPPED

DDLERROR DEFAULT IGNORE RETRYOP

MAP OWAS.*, TARGET OWAS.*;

MAPEXCLUDE OWAS.SYS_IMPORT_FULL_01, TARGET OWAS.SYS_IMPORT_FULL_01;

MAPEXCLUDE OWAS.SYS_EXPORT_SCHEMA_01, TARGET OWAS.SYS_EXPORT_SCHEMA_01;

 

然后重新启动进程。