Today, after trying unsuccessfully to drop my temporary tables, and subsequent fails due to object locks, I tried to find who's locking my table.
Not an easy task, so I dig a little and found this amazing script that solved my problem. If you have the same problem, read here how to list all locked objects.
Not an easy task, so I dig a little and found this amazing script that solved my problem. If you have the same problem, read here how to list all locked objects.
No comments:
Post a Comment