Select to view content in your preferred language

Remove Orphaned Geodatabase Locks

2449
2
09-11-2018 09:17 AM
ToddMcNeil2
New Contributor

How does one go about removing an orphaned lock on a feature class?  I've reviewed the geodatabase administration information which suggested the following.

Right-click on the schema, select Geodatabase Administration > Disconnect User.  However, it causes this error.

Any suggestions out there?

Todd

0 Kudos
2 Replies
Asrujit_SenGupta
MVP Alum

Which user are you connected with while trying to disconnect? It seems from the screenshot that the user doesn't have permission to disconnect.

To disconnect users from a geodatabase in Oracle, the geodatabase administrator must either be added to the DBA role or granted ALTER SYSTEM and SELECT_CATALOG_ROLE privileges

Manage connections to Oracle—Help | ArcGIS Desktop 

The geodatabase administrator in Oracle—Help | ArcGIS Desktop 

0 Kudos
ToddMcNeil2
New Contributor

That makes sense.  I'll check with my DBA administrators to see if I have an account with those privileges.  If I don't, I'll have one created.

0 Kudos