Oracle rebuild index partition online dating wolseley engine dating websites

by  |  10-Aug-2016 18:51

oracle rebuild index partition online dating-43

Oracle does not support partitioning of clustered tables or indexes on clustered tables.

Interval partitioning is an extension to range partitioning in which, beyond a point in time, partitions are defined by an interval. However, in order for a local index to be unique, the partitioning key of the table must be part of the index's key columns.

Interval partitions are automatically created by the database when data is inserted into the partition. Unique local indexes are useful for OLTP environments.

You cannot explicitly add a partition to a local index.

Instead, new partitions are added to local indexes only when you add a partition to the underlying table.

Community Discussion