Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unlock table

430003Nov 7 2005 — edited Nov 8 2005
Hello, I have recently locked a partition,p_200404, in TABLE_M using:

lock table TABLE_M partition (p_200404) in exclusive mode nowait;

Any DML on this partition gives the error:

ORA-01502: index 'table_M index' or partition of such index is in unusable state

and when i try to rebuild the index using:

alter index 'table_m index' rebuild partition p_200404

it gives me the error:
ORA-00069: cannot acquire lock -- table locks disabled for TABLE_M.

What i want to do is unlock this partition, but, not exactly sure how. I know it says to free the lock you have to perform a COMMIT, ROLLBACK, or SAVEPOINT, but, what is the syntax for this? I've tried
to simply drop the whole table but again I get the ORA-00069 error. Please help.


Thanks,

Tin Hoang
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2005
Added on Nov 7 2005
3 comments
1,391 views