Quote Originally Posted by tamilselvan
(ALTER TABLE xxxx MOVE TABLESPACE yyyy).
That would be perfect! I'm getting this error when I do that:

SQL> alter table el_scanqueue move tablespace aq_2;
alter table el_scanqueue move tablespace aq_2
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified