DROP_CHANGE_TABLE Procedure

This procedure drops an existing change table.

Syntax

DBMS_LOGMNR_CDC_PUBLISH.DROP_CHANGE_TABLE (
owner	IN VARCHAR2,
change_table_name	IN VARCHAR2,
force_flag	IN CHAR)

Parameters

Table 25-10 DROP_CHANGE_TABLE Procedure Parameters

Parameter	Description
owner	Name of the schema that owns the change table.
change_table_name	Name of the change table that is being dropped.
force_flag	Drops the change table, depending on whether or not there are subscriptions making references to it, as follows:
	Value Y	Description Drops the change table even if there are subscriptions making references to it.
	N	Drops the change table only if there are no subscribers referencing it.

Exceptions

Table 25-11 DROP_CHANGE_TABLE Procedure Exceptions

Exception	Description
ORA-31421	The specified change table does not exist. Check the specified change table name to see that it matches the name of an existing change table.
ORA-31422	Owner schema does not exist.
ORA-31424	The specified change table has active subscriptions, and thus it cannot be dropped. If you must drop the table, use the force_flag parameter to immediately drop the change table from all of the subscribers.
ORA-31441	Table is not a change table. You attempted to execute the DROP_CHANGE_TABLE procedure on a table that is not a change table.

Example

EXECUTE DBMS_LOGMNR_CDC_PUBLISH.DROP_CHANGE_TABLE ( \

OWNER => 'cdc1', \
CHANGE_TABLE_NAME => 'emp_ct' \
FORCE_FLAG => 'N')