Oracle PL/SQL: INDEXES: Alter Index Allocate Extent - Use the ALTER INDEX statement to change or rebuild an existing index. The index must be in your own

Quick Search:

Oracle PL/SQL: INDEXES: Alter Index Allocate Extent

Jump to:

Category: >> Oracle PL/SQL >> INDEXES: Alter Index Allocate Extent

<< last

next >>

Snippet Name: INDEXES: Alter Index Allocate Extent

Description: Use the ALTER INDEX statement to change or rebuild an existing index. The index must be in your own schema or you must have ALTER ANY INDEX system privilege.

Also see:
» INDEXES: View table indexes
» INDEXES: Analyze Index
» INDEXES: Block Dump
» INDEXES: Rebuild Reverse
» INDEXES:
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» INDEXES: Alter Index Parallel
» INDEXES: Alter Index Deallocate Unused
» INDEXES: Virtual / NoSegment
» INDEXES: Reverse Key Indexes
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» INDEXES: Unique indexes
» INDEXES: Parallel Index
» INDEXES: Compute Statistics
» INDEXES: SORT and NOSORT
» INDEXES: Function-Based Index
» INDEXES: DROP index
» INDEXES: Alter index
» INDEXES: Single Column Non-unique
» INDEXES: Index Usage Notes
» Compressed Indexes
» Create INDEX

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 11th, 2009

-- syntax:
ALTER INDEX <index_name>
 
 
- example: 
SELECT SUM(bytes), SUM(blocks)
FROM user_extents
WHERE segment_name = 'IDX_SALES_REGION';
 
ALTER INDEX idx_sales_region ALLOCATE EXTENT;
 
SELECT SUM(bytes), SUM(blocks)
FROM user_extents
WHERE segment_name = 'IDX_SALES_REGION';
 
ALTER INDEX idx_sales_region ALLOCATE EXTENT;
 
SELECT SUM(bytes), SUM(blocks)
FROM user_extents
WHERE segment_name = 'IDX_SALES_REGION';
 
ALTER INDEX idx_sales_region ALLOCATE EXTENT;
 
SELECT SUM(bytes), SUM(blocks)
FROM user_extents
WHERE segment_name = 'IDX_SALES_REGION';
 
ALTER INDEX idx_sales_region ALLOCATE EXTENT;
ALTER INDEX idx_sales_region ALLOCATE EXTENT;
ALTER INDEX idx_sales_region ALLOCATE EXTENT;
 
SELECT SUM(bytes), SUM(blocks)
FROM user_extents
WHERE segment_name = 'IDX_SALES_REGION';