To Drop Tablespace in oracle

SQL> drop tablespace kk including contents;
Tablespace dropped.

SQL>
SQL> select username from dba_users:
It will display all the username in the DB

SQL> select name from v$database;
NAME
ORCL
It will display the DB name


Sql> select count(*) from user_objects;
It will display all the objects in that schema.