Interval in Oracle Partitioning?

Interval in Oracle Partitioning?

Interval partitioning is an enhancement to range partitioning in Oracle 11g and interval partitioning automatically creates time-based partitions as new data is added. ... For example, if a table was used to store sales data, it might be range partitioned by a DATE column, with each month in a different partition.

How do I add an interval partition to an existing table in Oracle?

You cannot partition an existing non-partitioned table. In general, you'll need to create a new partitioned table, move the data from the existing table to the new table (probably using a direct-path insert with parallel DML), drop the old table, and rename the new table to use the old name. You can do that manually.

How do I add a partition to an interval partitioned table?

You cannot explicitly add a partition to an interval-partitioned table. The database automatically creates a partition for an interval when data for that interval is inserted.

Chloe Bennett
Author

Chloe Bennett

Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.