Oracle Database Discussions

hi

I want to do an test example for change data capture in "Asynchronous HotLog " mode .

First , i create a CHANGE TABLE on "SCOTT.TEST" table in a CHANGE SET called "scott changes" :

------

BEGIN
DBMS_CAPTURE_ADM.PREPARE_TABLE_INSTANTIATION(TABLE_NAME => 'SCOTT.TEST');
END;

------

BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
change_set_name => 'scott changes',
description => 'Change set for test table',
change_source_name => 'HOTLOG_SOURCE',
stop_on_ddl => 'y',
begin_date => sysdate
);
END;

------

BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE(
owner => 'cdcpub',
change_table_name => 'test_ct',
change_set_name => 'scott changes',
source_schema => 'scott',
source_table => 'test',
column_type_list => ' C1 VARCHAR2(50) , C2 VARCHAR2(50) , C3 VARCHAR2(50) ',
capture_values => 'both',
rs_id => 'y',
row_id => 'n',
user_id => 'y',
timestamp => 'n',
object_id => 'n',
source_colmap => 'n',
target_colmap => 'y',
options_string => 'TABLESPACE ts_cdcpub');
END;

-------

and finally i enable cdc :

BEGIN
DBMS_CDC_PUBLISH.alter_change_set(
change_set_name => 'SCOTT CHANGES',
enable_capture => 'y');
END;


-----

until now , all things work correctly and changes on ""TEST" table , log in "test_ct" table in cdcpub (the owner of test_ct) .
but when i execute an ddl command on "TEST" table (alter table SCOTT.TEST drop column C3;) , it shows me in alert log :

Change Data Capture received DDL for change set SCOTT CHANGES
Change Data Capture received DDL and stopping: -- Add/modify columns
alter table SCOTT.TEST add c3 VARCHAR2(50)


and when i try to enable it again after recover :

BEGIN
DBMS_CDC_PUBLISH.ALTER_CHANGE_SET(
change_set_name => 'SCOTT CHANGES',
recover_after_error => 'y',
remove_ddl => 'Y',
stop_on_ddl => 'y',
enable_capture => 'y');
END;
/


it's show me :

Errors in file /u01/app/oracle/admin/DB210/bdump/db210_p003_15130.trc:
ORA-10388: parallel query server interrupt (failure)
Sat Dec 13 13:21:03 2008
Streams APPLY A001 with pid=33, OS id=15190 stopped
Sat Dec 13 13:21:03 2008
Errors in file /u01/app/oracle/admin/DB210/bdump/db210_a001_15190.trc:
ORA-12801: error signaled in parallel query server P004
ORA-24047: invalid agent name CDC$C_SCOTT CHANGES, agent name should be of the form NAME



i don't now way it not work correctly ????

thx in adv.