![]() ![]() If you are altering or rebuilding an entire index, then the string must refer to index-level parameters. The maximum length of the parameter string is 1000 characters. This clause specifies the parameter string that is passed uninterpreted to the appropriate ODCI indextype routine. This clause is valid only for domain indexes in a top-level ALTER INDEX statement and in the rebuild_clause. The logical rowid excludes columns that are part of the index key. You cannot specify ONLINE for a bitmap join index or a cluster index.įor a nonunique secondary index on an index-organized table, the number of index key columns plus the number of primary key columns that are included in the logical rowid in the index-organized table cannot exceed 32. If you specify ONLINE and subsequently issue parallel DML statements, then Oracle Database returns an error. Parallel DML is not supported during online index building. Online indexes are subject to the following restrictions: Specify ONLINE to allow DML operations on the table or partition during rebuilding of the index. For full information on these clauses, refer to index_compression in the documentation on CREATE INDEX. The index_compression clauses have the same semantics for CREATE INDEX and ALTER INDEX. Specify the advanced_index_compression clause to enable or disable advanced index compression for the index. Specify the prefix_compression clause to enable or disable prefix compression for the index. Use the index_compression clauses to enable or disable index compression for the index. You cannot rebuild an online index that is used to enforce a deferrable unique constraint. REBUILD PARTITION).įor a local index on a hash partition or subpartition, the only parameter you can specify is TABLESPACE. You cannot rebuild a local index, but you can rebuild a partition of a local index ( ALTER INDEX. You can rebuild an index partition only if the index is not marked IN_PROGRESS or FAILED and the partition is not marked IN_PROGRESS. You can rebuild an index only if the index is not marked IN_PROGRESS. You can specify only the PARAMETERS clause (either for the index or for a partition of the index) or the parallel_clause. You can specify PCTFREE in all other forms of the ALTER INDEX statement. You cannot change the value of the PCTFREE parameter for the index as a whole ( ALTER INDEX) or for a partition ( ALTER INDEX. You cannot specify the deallocate_unused_clause in the same statement as the rebuild_clause. You must rebuild each partition or subpartition, as described for the PARTITION clause. You cannot rebuild an entire partitioned index. Instead, you must drop and then re-create it. You cannot rebuild a bitmap index that is marked INVALID. You cannot rebuild an index on a temporary table. The rebuilding of indexes is subject to the following restrictions: ![]() If the index was created with the COMPATIBLE initialization parameter set to 10.0.0 or greater, then the rebuilt index will contain the index key and all the primary key columns of the table, including those also in the index key. Therefore, if the index was created with the COMPATIBLE initialization parameter set to less than 10.0.0, the rebuilt index will contain the index key and any of the primary key columns of the table that are not also in the index key. When you rebuild the secondary index of an index-organized table, Oracle Database preserves the primary key columns contained in the logical rowid when the index was created. Refer to ALTER TABLE for a complete description of this clause. If you omit KEEP, then all unused space is freed. If the initial extent becomes smaller than INITIAL, then INITIAL is set to the value of the current initial extent. If the number of remaining extents is less than MINEXTENTS, then MINEXTENTS is set to the current number of extents. The KEEP clause lets you specify the number of bytes above the high water mark that the index will have after deallocation. Refer to deallocate_unused_clause for a full description of this clause. You cannot specify this clause and also specify the rebuild_clause. You cannot specify this clause for an index on a temporary table. If index is a local index on a composite-partitioned table, then Oracle Database deallocates unused space from each index subpartition.ĭeallocation of space is subject to the following restrictions: If index is range-partitioned or hash-partitioned, then Oracle Database deallocates unused space from each index partition. Use the deallocate_unused_clause to explicitly deallocate unused space at the end of the index and make the freed space available for other segments in the tablespace. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |