Programmer Guide : Transaction Log Reader : Partitioning and filtering log records : Creating and deleting partitions
  
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.
See also
Partitioning and filtering log records