ORA-31456 While Executing DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE (Doc ID 2219294.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

Calling DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE fails as seen below:

BEGIN
  DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE (
  'CDCPUB',
  'CT_BPM_STEP',
  'CS_SF',
  'SA',
  'TABLE_BPM_STEP',
  'OBJID VARCHAR2(31),DEV NUMBER,ID VARCHAR2(19),NAME
VARCHAR2(128),SVC_NAME VARCHAR2(128),SHOWPAGE_NAME VARCHAR2(128),REF_PROC_NAME
VARCHAR2(765),REF_PROC_VERSION VARCHAR2(64),REF_STEP_NAME
VARCHAR2(128),ASSIGNEE_TYPE NUMBER,ASSIGNEE_EXPR VARCHAR2(255),STEP_TYPE
NUMBER,DESCRIPTION VARCHAR2(512),START_FUNC VARCHAR2(255),SUBPROCESS_NAME
VARCHAR2(765),SUBPROCESS_VERSION VARCHAR2(64),FORECAST_DURATION_SEC
NUMBER,AIF_OPERATION_ID VARCHAR2(255),CAT_ITEMS
VARCHAR2(1024),SUBPROCESS_PACKAGE VARCHAR2(765),SUBPROCESS_SEARCH_PKG
NUMBER,PARENT2PROCESS
VARCHAR2(31)',
  'both',
  'y',
  'n',
  'n',
  'n',
  'n',
  'n',
  'y',
  'TABLESPACE AMD_MEDIUM_TBL');
END;
/


ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 829

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