Remove Orphaned Geodatabase Locks

1854
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 Regular Contributor

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