Oracle database user Deletions and tablespaces

Log on as a system user to find the user who needs to be deleted:

--Find Users

SELECT * from dba_users;

--Find the path to the workspace
SELECT * from dba_data_files;

--Delete User
Drop user name cascade;
--Delete Table space
Drop tablespace tablespace name including contents and datafiles cascade constraint;

For example: Delete user name becomes XXX, tablespace name is tableplace_xxx

--delete users, and cascade relationships are also removed
Drop user Xxxcascade;
--Delete table space, and the corresponding tablespace file is also deleted
Drop tablespace tableplace_xxx including contents and datafiles cascade constraint;

Oracle database user Deletions and tablespaces