-- Erstellen einer Subcription:

BEGIN
       DBMS_CDC_SUBSCRIBE.CREATE_SUBSCRIPTION(
       change_set_name   => 'SYNC_SET',
       description       => 'Change data for test',
       subscription_name => 'TEST');
END;
/

select * from DBA_SUBSCRIPTIONS



  

  
HANDLE
  
SET_NAME
  
USERNAME
  
CREATED
  
STATUS
  
EARLIEST_SCN
  
LATEST_SCN
  
DESCRIPTION
  
LAST_PURGED
  
LAST_EXTENDED
  
SUBSCRIPTION_NAME
  
  
    
1
    
SYNC_SET
    
DEPLOY
    
05.09.2009 09:56:21
    
N
    
1
    
0
    
Change data for test
    
 
    
 
    
TEST
  



-- Erstellen des Subscrib-Views

BEGIN
       DBMS_CDC_SUBSCRIBE.SUBSCRIBE(
       subscription_name => 'TEST',
       source_schema     => 'DEPLOY',
       source_table      => 'DEPT',
       column_list       => 'deptno, dname, loc',
       subscriber_view   => 'V_SUBS_DEPT');
END;
/

--Oracle erstellt damit den folgenden View:

CREATE OR REPLACE VIEW deploy.v_subs_dept
AS
SELECT operation$, cscn$, commit_timestamp$,   row_id$, rsid$, timestamp$,
  "DEPTNO", "DNAME", "LOC"
  FROM "DEPLOY"."CLS_DEPT"
  WHERE cscn$ >= 1
  AND cscn$ <= 0 WITH READ ONLY