Partitioning Oracle tables

If a single column partitioning scheme has been implemented within the Oracle target schema, the Gateway for Oracle can be configured to make use of this partitioning for more efficient SQL updates.

You can define an additional table column (for example, FirstOccurrence) which is then used to restrict the part of the database that Oracle searches, rather than searching the whole database. The gateway will use this partitioning field in the WHERE clause of updates. To specify that the gateway uses Oracle partitioning, set the Oracle.UsePartitioning property to TRUE. To define the Oracle partitioning field, use the Oracle.PartitioningField property.

Note: You can only use Oracle partitioning when you are running the gateway in reporter mode. See Audit mode and reporter mode.