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.