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 WZOA_TABLESPACE

DATAFILE '/u01/app/oracle/oradata/racdb/wzoa_tablespace.dbf' SIZE 10000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING ONLINE SEGMENT SPACE MANAGEMENT AUTO

create user wzoa identified by wzzf88969631 default tablespace WZOA_TABLESPACE quota unlimited on WZOA_TABLESPACE;

grant dba to wzoa;