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


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$ >= 10151264302975
  AND cscn$ <= 10151264491090 WITH READ ONLY
/

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


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$ >= 10151264491091
  AND cscn$ <= 10151264491090 WITH READ ONLY
/