Cannot drop or rename table

Database
Enthusiast

Cannot drop or rename table

Hi fellows, We want to drop table BD.TABLA1; but we can´t. After some minutes the session ID shows that the table is locked and operation won't show any kind of error. So, I kill the session through viewpoint. When I try to rename it but this operation shows the same behavior, I mean it never ends. The table is available for select and shows records normally. I saw that any session or user is locking the table before I try to drop or rename it. It is necessary to drop that table. please, How can I drop the table?? Thanks in advance
  • DROP Table
3 REPLIES
Junior Contributor

Re: Cannot drop or rename table

Check if 

LOCK TABLE BD.TABLA1 NOWAIT drop table BD.TABLA1;

results in:

7423 Object already locked and NOWAIT. Transaction Aborted.

 

Did you check the blocker info in Viewwpoint?

 

If no blcoking info is available there might be a left-over backup lock:

RELEASE LOCK BD.TABLA1;

 

 

Enthusiast

Re: Cannot drop or rename table

Hi I will do this tomorrow at afternoon. This is because we will have a couple of hours to work with this table. Thank you for your response. will inform the results.
Enthusiast

Re: Cannot drop or rename table

Hi all, the table is working well now. thanks