1. select * from all_users;
2. select file_name, tablespace_name from dba_data_file;
3. select table_name, tablespace_name from dba_tables;

You'll never walk alone !!!