I want to move an index from tablespace TS1 to tablespace TS2. Tablespace TS2 has 700mb free. The index size is 100mb.
I tried to do this with alter index 'index_name' rebuild online storage(initial 5m next 5m minextents 2 pctincrease 0) tablespace ts02;
It is giving me the ora-01659: unable to allocate MINEXTENTS beyond 8 in tablespace TS2.
Does any one know why?