8 Replies Latest reply on Feb 18, 2013 4:17 PM by Ben Speckhard-Oracle

    Unlock Rows in LIVE workspace

    mike_adn
      Hi,

      Is there a way to unlock rows locked by other users using the Schema Owner account?

      I tried to execute DBMS_WM.unlockrows('LIVE','ROADS_GEOM','FEATID > 0','USER','ES'); and DBMS_WM.unlockrows('LIVE','ROADS_GEOM','FEATID > 0','ALL','ES');

      But when I checked the _LOCK views, there are still Locked Rows by other Users in LIVE Workspace.

      Thanks in Advance.

      Edited by: rcx4009v2 on Jan 29, 2013 8:02 PM