EXTEND_WINDOW Procedure

This procedure sets the subscription window boundaries (low-water and high-water mark) so that new change data can be seen.

Syntax

DBMS_LOGMNR_CDC_SUBSCRIBE.EXTEND_WINDOW (
subscription_handle	IN NUMBER)

Parameters

Table 26-8 EXTEND_WINDOW Procedure Parameters  

Parameter	Description
subscription_handle	Unique number of the subscription handle that was returned by a previous call to the GET_SUBSCRIPTION_HANDLE procedure.

Exceptions

Table 26-9 EXTEND_WINDOW Procedure Exceptions

Exception	Description
ORA-31425	The specified subscription handle does not exist or it does not belong to this user or application.
ORA-31429	The subscription handle must be activated before you use the EXTEND_WINDOW procedure. Call the ACTIVATE_SUBSCRIPTION procedure for this subscription handle and then try the original command again.
ORA-31430	The subscriber view was not dropped prior to making this call. Call the DROP_SUBSCRIBER_VIEW procedure and then try the original command again.

Usage Notes

• Until you call the EXTEND_WINDOW procedure to begin capturing change data, the subscription window remains empty.
  • The first time that you call the EXTEND_WINDOW procedure, it establishes the initial boundaries for the subscription window.

  • Subsequent calls to the EXTEND_WINDOW procedure extend the high-water mark of the subscription window so that new change data can be seen.

Example

EXECUTE sys.DBMS_CDC_SUBSCRIBE.EXTEND_WINDOW( \
subscription_handle=>:subhandle);