I have a local index built to cover the table made up of 3 partitions. The local index and data partition are on different tablespace and datafiles. For some reasons, I need to delete one of the exisiting partitions and create a new one. When I load data to the new partition, I discovered that the local index is built upon the datafile of the new added partition, but not the datafile which holds the exisiting local index.
Q) How can the local index be adjusted, so that the index information of the new added partition will be built on the exisitng local index tablespace rather than the new data partition tablespace?
thanks a million.
'alter index modify default attributes' clause.
O believe that default attributes can be tested by quering DBA_INDEXES.tablespace_name, etc
Click Here to Expand Forum to Full Width