1. SQL Language Reference
  2. SQL Statements: CREATE JSON RELATIONAL DUALITY VIEW to CREATE SCHEMA
  3. CREATE LOGICAL PARTITION TRACKING

CREATE LOGICAL PARTITION TRACKING

Purpose

Use the CREATE LOGICAL PARTITION TRACKING statement to define a logical partitioning scheme on a table for being leveraged by materialized views and logical partition change tracking. You can define the logical partitions of your tables independently of any existing or non-existing partitioning schema of a table.

Syntax

create_logical_partition_tracking::=


Description of create_logical_partition_tracking.eps follows
Description of the illustration create_logical_partition_tracking.eps

Semantics

Logical partition tracking is supported on a single key column within the table. The datatype of the key column can be of the following data types: NUMBER, DATE, CHAR, VARCHAR, VARCHAR2, TIMESTAMP, TIMSTAMP WITH TIME ZONE.

Only RANGE and INTERVAL logical partitions are supported on the base table.

See Also: