Hi,
Using oracle 11.2.0.3 and moving data to another tablespace - after this and check the status of global indexes on the partitioned tables they show as UNUSABLE - previously VLAID.
As such when try insert afterwards into table get ORA-01502 index or partition of such index in unusable state
alter table retailer_transaction rename partition SYS_P64937 to PART_201505;
alter table retailer_transaction move subpartition SYS_SUBP64933 tablespace RTRN_PART_201505;
alter table retailer_transaction move subpartition SYS_SUBP64934 tablespace RTRN_PART_201505;
alter table retailer_transaction move subpartition SYS_SUBP64935 tablespace RTRN_PART_201505;
alter table retailer_transaction move subpartition SYS_SUBP64936 tablespace RTRN_PART_201505;
alter table retailer_transaction modify default attributes for partition PART_201505 tablespace RTRN_PART_201505;
Whilst this is test database as trying this out on this something we may need to do on periodic basis on live database but would have to rebuild the indexes if this was case.
Anyway of avoiding this indexes going into UNUSABLE state after moving data to another tablespace.
Thanks