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 .
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.