Showing posts with label ORA-01923: CASCADE aborted. Show all posts
Showing posts with label ORA-01923: CASCADE aborted. Show all posts

Friday, 20 January 2012

ORA-01923: CASCADE aborted, objects locked by another user

ORA-01923: CASCADE aborted, objects locked by another user

Cause: Cannot drop the user s objects; someone has them locked.

Action: Use the lock monitor to determine who has the objects locked.