Cause
The table in ALTER TABLE MODIFY SUBPARTITION { UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES } statement is not partitioned by Composite Range method which is illegal.
The table in ALTER TABLE MODIFY SUBPARTITION { UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES } statement is not partitioned by Composite Range method which is illegal.
Bring tablespace online before attempting the operation.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
Browse all solutions to database errors from Oracle, MS SQL, or MySQL