What Changes Are Not Captured?

Before you decide to use Streams replication, you must confirm that required changes could be captured by the capture process or synchronous capture process. You may have to deploy a workaround or other means to replicate data if you find that the objects contain unsupported data types or are subjected to unsupported replication operations, such as the TRUNCATE table command for synchronous capture process.

Neither the capture process nor the synchronous capture process captures any changes made to objects in SYS or SYSTEM or changes made to schemas for Oracle ConText Cartridge, Oracle Intelligent Agent, Oracle Data Miner, Oracle Database Vault, Oracle Rules Manager and Expression Filter, Oracle Label Security, Oracle Spatial, OracleMultimedia, Oracle OLAP, Oracle interMedia, Oracle Time Series, Oracle Enterprise Manager, Oracle Workspace Manager, and SQL XML Manager. These schemas are listed here: