Oracle delete rule cascade

Am suppose to compare it to the ALTER index REBUILD My question is:. The Behavior of the “ Alter Table/ Index Move Rebuild ” Commands. Can I do an Alter Index rebuild to move an index to an index tablespace while the database is up? We are a 24xoperation with . ALTER INDEX SYS_IL0000265968C00002$$ REBUILD TABLESPACE TEST * ERROR at line 1: ORA-02327: cannot create index on . Moving an index from one tablespace to another tablespace is very easy task.

It can be accomplished by using rebuild option: ALTER INDEX. If it is done at the tablespace level then every newly created index or table in this. Move the index partition to a new tablespace with the following command: alter index index_name rebuild partition part_name tablespace.

Oracle only supports partitioning for tables and indexes ; it does not support. ALTER TABLE MOVE PARTITION may be used to change the tablespace in .