User names and tablespace names

Select all schema user names

select username from dba_users;

Select all tablespace names

select tablespace_name from dba_tablespaces;

Create a simple tablespace

CREATE TABLESPACE POOL_TS
  DATAFILE 'pool_ts.dat'
  SIZE 20M AUTOEXTEND ON;