start with oracle - how to drop or delete a user in oracle
How to drop/delete a User in Oracle
DROP USER ABC CASCADE;
#Specify CASCADE to drop all objects in the user's schema before dropping the user.
#You must specify this clause to drop a user whose schema contains any objects.