Try OpenEdge Now
skip to main content
Managing Change Data Capture in Databases
Managing Change Data Capture in a Database : Deleting a Change Data Capture policy
 

Deleting a Change Data Capture policy

You can delete a CDC policy of a table from the Change Data Capture Table summary page.
Note: Deleting a current CDC policy of a source table deletes the change table and all the previous policies associated with that source table.
To delete a CDC policy:
1. From the OpenEdge Management console menu, select Database Administration > Go to Database Administration.
The Database Administration page appears.
2. From the list of database connections, select the required connection.
The database connection home page appears.
3. In the Storage Management section, click Change Data Capture Tables list.
The Change Data Capture Tables list page appears.
4. From the list, click the table name for which you want to delete a CDC policy.
5. In the Change Data Capture Table summary page, select the required policy and click Delete.
You can select multiple policies or click Select All to select all available policies for that table.
6. Click Yes in the dialog box to confirm deletion.
Note: You cannot delete a CDC policy for a table if there are any CDC change tracking records and change records associated with it. So, ensure that you remove them from the table, if any, before deleting the CDC policy.