Creating and deleting partitions

Programmer Guide : Transaction Log Reader : Partitioning and filtering log records : Creating and deleting partitions

The Log Reader partitions are be created, modified, and deleted with SQL statements.

About this task

The partition settings are transactional and persistent.

Procedure

Create partitions with the following command:

CREATE LOGREADER PARTITION <partition-name

Delete (drop) partitions with the following command:

DROP LOGREADER PARTITION <partition-name

Add or remove tables from a partition with the following command:

ALTER LOGREADER PARTITION <partition-name> {ADD | DROP} TABLE <table-name>

Note When a table is part of a partition, it cannot be dropped or altered. The only ALTER statement available is ALTER LOGREADER PARTITION ... DROP TABLE.