topic Re: Unable to delete user schema. SDE 9.3.1, Windows Server 2008 64bits in Data Management Questions https://community.esri.com/t5/data-management-questions/unable-to-delete-user-schema-sde-9-3-1-windows/m-p/590043#M33319 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>Some help?</SPAN><BR /><SPAN>I don't mind if the method to remove these user schemas doesn't follow the "normal way".</SPAN><BR /><BR /><SPAN>Thank you in advance,</SPAN><BR /><SPAN>Victor</SPAN></BODY></HTML> Wed, 29 Jun 2011 06:22:05 GMT VictorGonzalez3 2011-06-29T06:22:05Z Unable to delete user schema. SDE 9.3.1, Windows Server 2008 64bits https://community.esri.com/t5/data-management-questions/unable-to-delete-user-schema-sde-9-3-1-windows/m-p/590042#M33318 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>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:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">sdesetup -o delete -d ORACLE10G -i 5252:GDB_HUMEDALES -u GDB_HUMEDALES -p ******</BLOCKQUOTE><BR /><BR /><SPAN>But there are 2 schemas that shows this answer:</SPAN><BR /><BR /><SPAN>"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."</SPAN><BR /><BR /><SPAN>Well, how can I knew what other data is registered to delete it?</SPAN><BR /><SPAN>I had a look to TABLE_REGISTRY table but all tables there are in the own instance.</SPAN><BR /><BR /><SPAN>Any idea?</SPAN><BR /><BR /><SPAN>Best regads,</SPAN><BR /><SPAN>Victor</SPAN></BODY></HTML> Mon, 27 Jun 2011 11:57:41 GMT https://community.esri.com/t5/data-management-questions/unable-to-delete-user-schema-sde-9-3-1-windows/m-p/590042#M33318 VictorGonzalez3 2011-06-27T11:57:41Z Re: Unable to delete user schema. SDE 9.3.1, Windows Server 2008 64bits https://community.esri.com/t5/data-management-questions/unable-to-delete-user-schema-sde-9-3-1-windows/m-p/590043#M33319 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>Some help?</SPAN><BR /><SPAN>I don't mind if the method to remove these user schemas doesn't follow the "normal way".</SPAN><BR /><BR /><SPAN>Thank you in advance,</SPAN><BR /><SPAN>Victor</SPAN></BODY></HTML> Wed, 29 Jun 2011 06:22:05 GMT https://community.esri.com/t5/data-management-questions/unable-to-delete-user-schema-sde-9-3-1-windows/m-p/590043#M33319 VictorGonzalez3 2011-06-29T06:22:05Z