JR45054: STRUCTURAL REFRESH FAILS FOR A TABLE WITH A CONSTRAINT USING INDEX CLAUSE

Fix list for IBM InfoSphere Change Data Capture

APAR status

• Closed as program error.

Error description

• A structural refresh of a table includes the DDL for indices. If
  the table is created with a constraint that uses an index, the
  create index statement will fail with an "ORA-00955: name is
  already used by an existing object" error
  
  
  Error 319 KKKKK Dec 7, 2012 12:26:25 PM Failed to apply DDL
  'DROP TABLE "JR"."ABC"
    CREATE TABLE "JR"."ABC"
     ( "K" NUMBER(*,0),
  "B" CHAR(10),
  PRIMARY KEY ("K")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS
  LOGGING
    TABLESPACE "USERS" ENABLE,
  CONSTRAINT "ABC_U" UNIQUE ("B")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS
  LOGGING
    TABLESPACE "USERS" ENABLE
     ) SEGMENT CREATION DEFERRED
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS
  LOGGING
    TABLESPACE "USERS"
  
    CREATE UNIQUE INDEX "JR"."ABC_U" ON "JR"."ABC" ("B")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING
    TABLESPACE "USERS"
   ' on table "JR"."ABC".
  Database operation failed.
  A SQL exception has occurred. The SQL error code is '955'. The
  SQL state is: 42S01. The error message is:
  [CDC][Oracle JDBC Driver][Oracle]ORA-00955: name is already used
  by an existing object
  

Local fix

Problem summary

• CDC fails while refreshing a table selected for replication by a
  rules-based mapping when the table DDL contains a
  CONSTRAINT UNIQUE ... USING INDEX clause. The error shown in the
  event log is:
  
  "ORA-00955: name is already used by an existing object"
  
  This issue affects users running ISCDC 6.5.1 and ISCDC 6.5.2 for
  Oracle Redo with rule-based mappings using tables with the
  described characteristics.
  

Problem conclusion

• This issue is fixed by applying ISCDC 6.5.2 Interim Fix 21 for
  Oracle Redo.
  

Temporary fix

• Possible workarounds:
  - Change the source table to do not use a CONSTRAINT, or
  - Implement a User Exit to modify the DDL to be applied to the
  target.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IS CDC ORACLE

• Fixed component ID

  5724U7008

Applicable component levels

• R652 PSY

     UP

• R651 PSN

     UP