My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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//" leohighlights_url_top="http%3A//" 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');
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.



Nothing the same code working fine in 10.2 database version.


To view full details, 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 a vibrant support community of peers and Oracle experts.