Oracle deletes users and tablespaces, and oracle deletes

Oracle deletes users and tablespaces, and oracle deletes

1. view the tablespace and its name.
SQL> SELECT FILE_NAME, TABLESPACE_NAME FROM dba_data_files;


2. query the user and the corresponding tablespace
SQL> select username, default_tablespace from dba_users;


3. query the tablespace IN THE SYSTEM
SQL> select FILE_NAME, TABLESPACE_NAME from dba_data_files;


4. delete a user
SQL> drop user doiido cascade;


5. Delete tablespaces

SQL> drop tablespace doiido including contents and datafiles;