Oracle Database Discussions

Hello

I have to move a bunch of tables in a database to another tablespace. All goes well but one table which is locked in a very strange state.

Please look at this:

18-AUG-10 hot-oracenter-01 SYS oracentr1> alter table SYSTEM.ALEX_TEST2 move tablespace citrix_temp;
alter table SYSTEM.ALEX_TEST2 move tablespace citrix_temp
*
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for ALEX_TEST2

I look at the error description and the recommendation is to do this:

18-AUG-10 hot-oracenter-01 SYS oracentr1> alter table SYSTEM.ALEX_TEST2 enable table lock;
alter table SYSTEM.ALEX_TEST2 enable table lock
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


Hmmm... this doesnt work. Maybe I should try to manually lock the table:

18-AUG-10 hot-oracenter-01 SYS oracentr1> lock table system.alex_test2 in exclusive mode;
lock table system.alex_test2 in exclusive mode
*
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for ALEX_TEST2

Doesnt work. Lets see who's locking the table:

18-AUG-10 hot-oracenter-01 SYS oracentr1> select a.session_id,a.os_user_name,b.object_name from v$locked_object a, dba_objects b where a.object_id=b.object_id and object_name='ALEXT_TEST2';

no rows selected

Oooops. Im stuck.
The table has some "invisible lock" on it. Please help me understand whats going on here (and move, or even drop, the table).

Thank you

Guy