Originally posted by mike2000
I did kill the session which lock the tables, the session is gone; however, the lock tables still there.
I am not sure what you are trying to tell...some thing like this
You Kill Session X which holds lock on Table Y..after you do
you mean theres no entry in V$Locked_Object on table Y & still you feel theres lock on the table?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"