ORA-31489 : Invalid DDL Markers Value (Doc ID 836250.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

While creating change table in 11g, ORA-31489 error is received.

create user cdc identified by cdc;
grant connect, resource, dba to CDC;

connect cdc/cdc
begin
dbms_cdc_publish.create_change_table (
owner => 'cdc',
change_table_name => 'emp_cdc',
change_set_name => 'SYNC_SET',
source_schema => 'scott',
source_table => 'emp',
column_type_list => 'empno number, ename varchar2(10),
job varchar2(9), mgr number, hiredate date, deptno number',
capture_values => 'both',
rs_id => 'y',
row_id => 'n',
user_id => 'n',
timestamp => 'n',
object_id => 'n',
source_colmap => 'y',
target_colmap => 'y',
options_string => null
end;
/

ORA-31489 : Invalid DDL Markers Value
ORA-6512 : at "SYS.DBMS_CDC_PUBLISH", line 783
ORA-6512: at line 2

Changes

None

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