The DROP USER statement is used to remove a user from the Oracle RDBMS and optionally drop all objects owned by that user.
DROP USER username [ CASCADE ];
Example 1:
DROP USER username;
If username owns any objects (ie: tables, views, functions, … in its schema), you must specify CASCADE to drop all of these objects.
Example 2:
DROP USER username CASCADE;