My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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
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

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




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.