Extend usage in oracle

Oracle's EXTEND operator is used to allocate storage space to an existing partition in a partitioned table, increasing its size. Syntax: ALTER TABLE table_name EXTEND PARTITION partition_name FOR { storage (size) | MAXSIZE (size) }. Parameters include partition table name, partition name, storage space size or maximum storage space size, etc. The EXTEND operator extends indexes with USING INDEXES and excludes partitions with NOT INCLUDING PARTITION. Online or offline execution of EX

EXTEND usage in Oracle

The EXTEND operator in Oracle is used to convert Space is allocated to existing partitions in the partition table. After executing EXTEND, the size of the partition will be increased to the specified size.

Syntax:

<code>ALTER TABLE table_name
EXTEND PARTITION partition_name
FOR { storage (size) | MAXSIZE (size) }
[USING INDEXES (index_list)]
[NOT INCLUDING PARTITION partition_name]</code>

Parameters:

• table_name: Partition table name.
• partition_name: The name of the partition to be extended.
• storage (size): The size of storage space to be allocated to the partition.
• MAXSIZE (size): The maximum storage space size to be allocated to the partition.
• USING INDEXES (index_list): The index list to be extended when using the EXTEND operator.
• NOT INCLUDING PARTITION partition_name: The partition to exclude from the EXTEND operator.

Usage:

Here’s how to use the EXTEND operator in Oracle:

<code class="sql">-- 将空间分配给 PARTITION1 分区，大小为 50MB
ALTER TABLE my_table
EXTEND PARTITION PARTITION1
FOR STORAGE (50M);

-- 将 PARTITION2 分区的最大存储空间大小增加到 100MB
ALTER TABLE my_table
EXTEND PARTITION PARTITION2
FOR MAXSIZE (100M);

-- 将 PARTITION3 分区扩展，同时扩展索引 INDEX1 和 INDEX2
ALTER TABLE my_table
EXTEND PARTITION PARTITION3
FOR STORAGE (20M)
USING INDEXES (INDEX1, INDEX2);</code>

Notes:

• The EXTEND operator can only extend an existing partition.
• The maximum size of the partition depends on the database version and storage media.
• The EXTEND operator is a DDL operation and therefore requires submission to take effect.
• EXTEND operator can be executed online or offline, but online expansion may affect performance.
• Before extending the partition, make sure there is enough storage space available.

The above is the detailed content of Extend usage in oracle. For more information, please follow other related articles on the PHP Chinese website!