Select to view content in your preferred language

Unable to delete user schema. SDE 9.3.1, Windows Server 2008 64bits

923
1
06-27-2011 04:57 AM
VictorGonzalez3
New Contributor
Hi,
I'm trying to delete 5 user schemas with ArcSDE 9.3.1 from the geodatabase service 5252. OS Windows Server 2008 64bits. I have successfully deleted 3 of 5 schemas using statements like this:

sdesetup -o delete -d ORACLE10G -i 5252:GDB_HUMEDALES -u GDB_HUMEDALES -p ******


But there are 2 schemas that shows this answer:

"The Sshema geodatabase instance user owns data registeres in other geodatabase instances. Deleting a Schema geodatabase is allowed only if it it empty and the schema does not own any registered data in other geodatabase instances."

Well, how can I knew what other data is registered to delete it?
I had a look to TABLE_REGISTRY table but all tables there are in the own instance.

Any idea?

Best regads,
Victor
0 Kudos
1 Reply
VictorGonzalez3
New Contributor
Hi,
Some help?
I don't mind if the method to remove these user schemas doesn't follow the "normal way".

Thank you in advance,
Victor
0 Kudos