https://wiki.pplant.de/index.php?action=history&feed=atom&title=Gesperrte_Tabelle_entsperren 2026-05-06T02:32:42Z Versionsgeschichte dieser Seite in PPwiki MediaWiki 1.28.2 https://wiki.pplant.de/index.php?title=Gesperrte_Tabelle_entsperren&diff=10496&oldid=prev 2022-01-21T14:48:08Z

<p>Die Seite wurde neu angelegt: „==Unlocking an oracle table== 1) Get the object ID of the locked table: SELECT object_id FROM dba_objects WHERE object_name=&#039;YOUR TABLE NAME&#039;; 2) Get the SI…“</p> <p><b>Neue Seite</b></p><div>==Unlocking an oracle table== <br /> <br /> 1) Get the object ID of the locked table:<br /> SELECT object_id FROM dba_objects WHERE object_name='YOUR TABLE NAME';<br /> 2) Get the SID values for this ID:<br /> SELECT sid FROM v$lock WHERE id1=OBJECT ID FROM STEP1<br /> 3) Get the session values for these SIDs:<br /> SELECT sid, serial# from v$session where sid in (COMMA SEPARATED LIST OF SIDs FROM STEP2.)<br /> 4) Kill the sessions causing the lock:<br /> ALTER SYSTEM KILL SESSION (SID,SERIAL#)<br /> <br /> pair values from step 3 e.g. ALTER SYSTEM KILL SESSION '231,23454'</div>

Schreur