ORA-31452 running dbms_cdc_publish.alter_change_table (Doc ID 1402824.1)

Last updated on AUGUST 27, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

BEGIN
dbms_cdc_publish.alter_change_table (owner => 'SCOTT',
change_table_name => 'TEST_CDC',
operation  => 'ADD',
column_list  => 'test VARCHAR2(1)',
rs_id  => 'N',
row_id => 'N',
user_id  => 'N',
timestamp  => 'N',
object_id  => 'N',
source_colmap  => 'N',
<leo_highlight leohighlights_underline="true" leohighlights_url_bottom="http%3A//shortcuts.thebrowserhighlighter.com/leonardo/plugin/highlights/3_2/tbh_highlightsBottom.jsp?keywords%3Dtarget%26domain%3Dml3-awiz.us.oracle.com" leohighlights_url_top="http%3A//shortcuts.thebrowserhighlighter.com/leonardo/plugin/highlights/3_2/tbh_highlightsTop.jsp?keywords%3Dtarget%26domain%3Dml3-awiz.us.oracle.com" leohighlights_keywords="target" onmouseout="leoHighlightsHandleMouseOut('leoHighlights_Underline_0')" onmouseover="leoHighlightsHandleMouseOver('leoHighlights_Underline_0')" onclick="leoHighlightsHandleClick('leoHighlights_Underline_0')" id="leoHighlights_Underline_0" style="border-bottom: 2px solid rgb(255, 255, 150); background-color: transparent; background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 50%; -moz-background-size: auto auto; cursor: pointer; display: inline; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">target_colmap  => 'N');
END;
/
ORA-31452: invalid value for parameter, expecting : Y or N
ORA-06512: at 'SYS.DBMS_CDC_PUBLISH', line 820
ORA-06512: at line 3;

In this sample we are adding a column to the change table.

 

Changes

Nothing the same code working fine in 10.2 database version.

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