REPLICAT ABENDS WITH ORA-955 FOR DDLS AFTER TARGET TABLE WAS EXP/IMP from SOURCE (Doc ID 1541460.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.4 and later
Information in this document applies to any platform.

Symptoms

REPLICAT ABENDS WITH ORA-955 FOR DDLS AFTER TARGET TABLE WAS EXP/IMP from SOURCE


After export/import the table from source to target, replicat abends with ora-955.
Following is an example:

1. in source
create table s11 (a number);
alter table s11 add constraint s11_pk primary key (a) ;

the DDLs will be replicated to target fine.

2. in target
drop table s11;

3. export/import
export the table from source and import it to the target.
.
4. in source
alter table s11 drop constraint s11_pk cascade;
<== this is replicated fine to target, but index is not dropped

SQL> select table_name from dba_indexes where index_name='S11_PK';
TABLE_NAME
------------------------------
S11

5. still in source
alter table s11 rename to s12;
create table s10 (a number);
alter table s10 rename to s11;

now the S11_PK belongs to S12
SQL> select owner, table_name from dba_indexes where index_name='S11_PK';
OWNER TABLE_NAME
------------------------------ ------------------------------
A S12

6. in source
alter table s11 add constraint s11_pk primary key (a);

this DDL causes error at replicat:
.
2013-03-20 19:53:33 ERROR OGG-00519 Fatal error executing DDL
replication: error [Error code [955], ORA-00955: name is already used by an
existing object SQL alter table a.s11 add constraint s11_pk primary key (a)
/* GOLDENGATE_DDL_REPLICATION */], no error handler present.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms