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?