Hi ,
I had a small question.
I have an index with partitions (monthly). And I move old partitions to a different tablespace.
Normally I am using the alter index command with tablespace definition, this operation does cause some of my clients to wait until the index is moved successfully.. I was wondering if I can execute the alter index command ONLINE with tablespace defined?
Is there any other way to move index without affecting the clients?
Thanks
Saad