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
/