By default, all the log records that are generated by any application are returned. If you want to access the log records for only a subset of the database, you can specify Logreader (replication) partitions.
A Logreader partition is a named collection of tables. Different partitions can contain the same tables. Information about the partitions is stored in SYS_FEDT_DB_PARTITION and SYS_FEDT_TABLE_PARTITION system tables, see SYS_FEDT_DB_PARTITION and SYS_FEDT_TABLE_PARTITION.
Logreader partitions are created, modified, and deleted by using the following SQL statements.
The partition settings are persistent but not effective until the statements are committed.
▪ Delete (drop) partitions by using the DROP REPLICATION PARTITION statement, see DROP REPLICATION PARTITION.
▪ Add or remove tables from a partition by using the ALTER REPLICATION PARTITION statement, see ALTER REPLICATION PARTITION.
Note If a table is included in a Logreader partition, the table itself cannot be dropped or altered. You must drop the table from the partition (by using ALTER REPLICATION PARTITION ... DROP TABLE), before you can make any changes to the table.