What is the best way to delete a schema/user from ArcSDE/Oracle? Sure you can create a user using ArcToolbox, but there is no delete user!?
You would need to do this using the DROP USER command, for example in SQL*PLUS. Here is a helpful link:
Oracle Drop User Cascade
Retrieving data ...