AnsweredAssumed Answered

ORPHANED SDE USER OWNS DOMAINS

Question asked by trudnick on May 19, 2016
Latest reply on May 26, 2016 by trudnick

We have domains going many years back, and we discovered several domains that were user-created rather than administrator created.  The problem is that the person who owns the domain has been gone for years, and the Oracle account does not exist anymore.  I assumed I could recreate the user account, login as that user, and then delete the domain. 

 

Unfortunately, this has not worked.  I am getting a schema lock error as below.  The CS_DBLANKINSHIP is the new user that was created in Oracle.  Unfortunately, the domain owner shows as lowercase as 'cs_dblankinship'.  It seems like when I try to delete or modify the domain it is seeing my new user as different from the old because one is uppercase and one is lower?  You don't have a choice in Oracle to create a user with a name in lowercase, so I can't force the new user to look identical to the old one.  I can't delete or update the domain because I am not seen as the owner when I login.  I can't update the GDB_ITEMS table because it is in XML format.  Does anyone have any ideas how to fix this?

 

domainerror2.JPG

domainerror.JPG

Outcomes