Link to home
Start Free TrialLog in
Avatar of nesbit
nesbit

asked on

Unlocking locked tables

How can I unlock tables locked by a program that crashed, without having to restart the database instance?  The tables were locked EXCLUSIVE.
Avatar of nesbit
nesbit

ASKER

Adjusted points to 50
Avatar of nesbit

ASKER

Adjusted points to 100
ASKER CERTIFIED SOLUTION
Avatar of arh
arh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Arh is right.
In addition, if you are using Enterprise Manager in Windows 95 then you can also kill the session from the graphical "Top Sessions Manager" right-clicking on the crashed session.
Arh is right.
In addition, if you are using Enterprise Manager in Windows 95 then you can also kill the session from the graphical tool "Top Sessions Manager" right-clicking on the crashed session.