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';

create tablespace

conn fxwl/fxwl
select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;

CREATE TABLESPACE  EAS_D_FXWL_STANDARD
    DATAFILE '+SSD_DATA' SIZE 10000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO
    /

create user fxwl identified by fxwl default tablespace EAS_D_FXWL_STANDARD quota unlimited on EAS_D_FXWL_STANDARD;

grant dba to fxwl;