users

select * from all_users;

create schema(users)

select tablespace_name from user_tablespaces;

select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;

select USERNAME, DEFAULT_TABLESPACE from DBA_USERS where DEFAULT_TABLESPACE = 'DEV_DB';