Insert into DEPLOY.DEPT
   (DEPTNO, DNAME, LOC)
 Values
   (10, 'ACCOUNTING', 'NEW YORK');
COMMIT;

Ergibt einen Record in CLS_DEPT


  

  
OPERATION$
  
CSCN$
  
COMMIT_TIMESTAMP$
  
RSID$
  
ROW_ID$
  
TIMESTAMP$
  
DEPTNO
  
DNAME
  
LOC
  
  
    
I 
    
281474976710655
    
01.01.4000
    
1
    
AAAbloAAFAAAHz2AAA
    
06.09.2009 16:53:34
    
50
    
IT
    
EVERYWHER
  

--Start

BEGIN
   DBMS_CDC_SUBSCRIBE.ACTIVATE_SUBSCRIPTION(
       subscription_name => 'TEST');
END;
/


BEGIN
   DBMS_CDC_SUBSCRIBE.EXTEND_WINDOW(
       subscription_name => 'TEST');
END;



select * from DEPLOY.v_subs_dept


  

  
OPERATION$
  
CSCN$
  
COMMIT_TIMESTAMP$
  
ROW_ID$
  
RSID$
  
TIMESTAMP$
  
DEPTNO
  
DNAME
  
LOC
  
  
    
I 
    
10151264490285
    
06.09.2009 16:58:54
    
AAAbloAAFAAAHz2AAA
    
1
    
06.09.2009 16:53:34
    
50
    
IT
    
EVERYWHER