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::=
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:
-
Refreshing Materialized Views of the Data Warehousing Guide.