ALTER INDEX |
Modifie un index |
|---|---|
| Oracle Database SQL |
Syntaxe
|
ALTER INDEX [schema.]index [ENABLE] [DISABLE] [COALESCE] [UNUSABLE] [RENAME TO new_index_name] [[NO]LOGGING] [PCTFREE int] [PCTUSED int] [INITRANS int] [MAXTRANS int] [STORAGE storage_clause] [ALLOCATE EXTENT [SIZE int K | M]] [ALLOCATE EXTENT [DATAFILE 'filename']] [ALLOCATE EXTENT [INSTANCE int]] [DEALLOCATE UNUSED] [DEALLOCATE UNUSED KEEP int K | M] [[NO]MONITORING USAGE] [UPDATE BLOCK REFERENCES] [NOPARALLEL] [PARALLEL int] [MODIFY PARTITION partition COALESCE] [MODIFY PARTITION partition UNUSABLE] [MODIFY PARTITION partition UPDATE BLOCK REFERENCES] [MODIFY PARTITION partition PARAMETERS ('alter_partition_params')] [MODIFY PARTITION partition [ALLOCATE EXTENT [SIZE int K | M]] [ALLOCATE EXTENT [DATAFILE 'filename']] [ALLOCATE EXTENT [INSTANCE int]] [DEALLOCATE UNUSED] [DEALLOCATE UNUSED KEEP int K | M] [[NO]LOGGING] [PCTFREE int] [PCTUSED int] [INITRANS int] [MAXTRANS int] [STORAGE storage_clause] ] [RENAME [SUB]PARTITION old_name TO new_name] [DROP PARTITION partition] [SPLIT PARTITION partition AT (value_list)] [INTO (PARTITION [partition attrib_options], PARTITION [partition attrib_options])] [NOPARALLEL|PARALLEL int] [MODIFY DEFAULT ATTRIBUTES [FOR PARTITION partition] [TABLESPACE {tablespace|DEFAULT}] [[NO]LOGGING] [PCTFREE int] [PCTUSED int] [INITRANS int] [MAXTRANS int] [STORAGE storage_clause] ] [MODIFY SUBPARTITION subpartition UNUSABLE] [MODIFY SUBPARTITION subpartition [ALLOCATE EXTENT [SIZE int K | M]] [ALLOCATE EXTENT [DATAFILE 'filename']] [ALLOCATE EXTENT [INSTANCE int]] [DEALLOCATE UNUSED] [DEALLOCATE UNUSED KEEP int K | M] ] [[REBUILD | REBUILD NOREVERSE | REBUILD REVERSE | REBUILD [SUB]PARTITION partition] | [ [ONLINE] [COMPUTE STATISTICS] [TABLESPACE tablespace_name] [NOPARALLEL] [PARALLEL int] [[NO]LOGGING] [COMPRESS int] [NOCOMPRESS] [PCTFREE int] [PCTUSED int] [INITRANS int] [MAXTRANS int] [PARAMETERS ('odci_parameters')] [STORAGE storage_clause] ]] |
Description
Cette instruction permet d'effectuer la modification d'un index d'une table.
Voir également
Article - Les géants de l'informatique - Oracle
Dernière mise à jour : Lundi, le 11 mai 2015