OS : Solaris 9
My objective is to move an index from one tablespace to another.
alter index <index name> rebuild tablespace <tablespace name>
It fails with this error :
ORA-08104: this index object 36413 is being online built or rebuilt
I'll have only one day tomorrow during which I can try dropping and building the index or other options. Not sure if it would allow me to drop.
Looking forward to expert advice so that I can try all available options during the time window provided.