ACTIVATE_SUBSCRIPTION Procedure

The ACTIVATE_SUBSCRIPTION procedure indicates that a subscription is ready to start accessing change data.

Syntax

DBMS_CDC_SUBSCRIBE.ACTIVATE_SUBSCRIPTION (
subscription_handle	IN NUMBER)

Parameters

Table 26-6 ACTIVATE_SUBSCRIPTION 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-7 ACTIVATE_SUBSCRIPTION Procedure Exceptions

Exception	Description
ORA-31425	The specified subscription handle does not exist, or it does not belong to this user ID or application.
ORA-31439	The subscription is already active. You can activate a subscription only once.

Usage Notes

• The ACTIVATE_SUBSCRIPTION procedure indicates that you are finished subscribing to tables, and the subscription is ready to start accessing data.

• Once the subscriber activates the subscription:
  • No additional source tables can be added to the subscription.

  • The Change Data Capture system holds the available data for the source tables and sets the subscription window to empty.

  • The subscriber must use the EXTEND_WINDOW procedure to see the initial set of change data.

  • The subscription cannot be activated again.

Example

EXECUTE sys.DBMS_CDC_SUBSCRIBE.ACTIVATE_SUBSCRIPTION( \

SUBSCRIPTION_HANDLE=>:subhandle);