Table/index/domain intermedia index rebuilding/reorg
Hi all,
DB version 11.2.0.3
Q1) We have a table with normal index and domain indexes. We want to move this table and indexes to new tablespaces using alter table move and alter index move command.
We would like to know if we move the master table using move command, the domain index of this table will be affected or not. Also we required to rebuild the domain indexes, is there a simialr method of online reorg instead of droping and re-creating the domain index?
Q2) We do have BLOB columns on some of the tables we want to reorg to new tablespaces, and blob columns are stored on different tablespace than other columns. When we do alter table move to new tablespace, does the blob data affected and do we need to move the blob column as well?
We would like to know if we move the master table using move command, the domain index of this table will be affected or not. Also we required to rebuild the domain indexes, is there a simialr method of online reorg instead of droping and re-creating the domain index?
Q2) We do have BLOB columns on some of the tables we want to reorg to new tablespaces, and blob columns are stored on different tablespace than other columns. When we do alter table move to new tablespace, does the blob data affected and do we need to move the blob column as well?
0