In this tutorial, How to Drop user cascade oracle. You must have Oracle DROP USER system privilege.
Drop user cascade oracle
The syntax Drop a user as below
DROP USER HUUPV CASCADE;
The Oracle DROP USER CASCADE command drop a user and all owned objects.
Be careful: After the Oracle DROP USER CASCADE command cannot a rollback to re-create the USER.
Thought the article, you can use Drop user cascade oracle as above. I hope will this your helpful.