select * from DEPT;


  

  
DEPTNO
  
DNAME
  
LOC
  
  
    
10
    
ACCOUNTING
    
NEW YORK
  
  
    
20
    
RESEARCH
    
DALLAS
  
  
    
30
    
SALES
    
CHICAGO
  
  
    
40
    
OPERATIONS
    
BOSTON
  


Erstellen eines Change Tables


declare
begin
dbms_cdc_publish.create_change_table(
	owner => 'DEPLOY',
	change_table_name => 'CLS_DEPT',
	change_set_name => 'SYNC_SET',
	source_schema => 'DEPLOY',
	source_table => 'DEPT',
	column_type_list => '
	DEPTNO  NUMBER(2),
    DNAME   VARCHAR2(14),
    LOC     VARCHAR2(13)',
	capture_values=>'both',
	rs_id=>'Y',
	row_id=>'Y',
	user_id=>'N',
	timestamp=>'Y',
	object_id=>'N',
	source_colmap=>'N',
	target_colmap=>'N',
	options_string=>null);
end;
/
--
--Löschen eines Change Tables:
--

exec dbms_cdc_publish.drop_change_table('DEPLOY','CLS_DEPT','Y');


--
--Erweitern eines Change Tables um die Spalte Loc2
--

begin
dbms_cdc_publish.alter_change_table(
	owner => 'DEPLOY',
	change_table_name => 'CL_DEPT',
	operation    => 'ADD',
	column_list => 'LOC2  VARCHAR2(13)',
	rs_id=>'N',
	row_id=>'N',
	user_id=>'N',
	timestamp=>'N',
	object_id=>'N',
	source_colmap=>'N',
	target_colmap=>'N');
end;