Create user

CREATE USER TEST_SUH IDENTIFIED BY whoami
DEFAULT TABLESPACE users_tbs
TEMPORARY TABLESPACE temp
QUOTA 100M ON users_tbs
QUOTA UNLIMITED ON data_tbs;

Create tablespace: Undo Tablespace

CREATE TABLESPACE undo_tbs TEMPFILE '/opt/oracle/mydbs/data/mydbs_undo_tbs_01.tmp' SIZE 1g RETENTION GUARANTEE;

Create tablespace: Temporary Tablespace

CREATE TABLESPACE temp_tbs TEMPFILE '/opt/oracle/mydbs/data/mydbs_temp_tbs_01.tmp' SIZE 100m;

Create tablespace: Permanent Tablespace

CREATE TABLESPACE data_tbs DATAFILE '/opt/oracle/mydbs/data/mydbs_data_tbs_01.dbf' SIZE 100m;
CREATE TABLESPACE data_tbs DATAFILE '/opt/oracle/mydbs/data/mydbs_data_tbs_01.dbf' SIZE 100m FORCE LOGGING BLOCKSIZE 8k;
CREATE TABLESPACE data_tbs DATAFILE '/opt/oracle/mydbs/data/mydbs_data_tbs_01.dbf' SIZE 100m NOLOGGING DEFAULT COMPRESS EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
CREATE TABLESPACE data_tbs DATAFILE '/opt/oracle/mydbs/data/mydbs_data_tbs_01.dbf' SIZE 100m NOLOGGING
DEFAULT COMPRESS EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
CREATE BIGFILE TABLESPACE data_tbs DATAFILE '/opt/oracle/mydbs/data/mydbs_data_tbs_01.dbf' SIZE 10G;

Create spfile

CREATE SPFILE FROM PFILE;
CREATE SPFILE='/opt/oracle/admin/mydb/pfile/spfilemybd.ora' FROM PFILE='/opt/oracle/admin/mydb/pfile/initmybd.ora';

Create profile

CREATE PROFILE development_profile
LIMIT
SESSIONS_PER_USER 2 CONNECT_TIME 100000 IDLE_TIME 100000
LOGICAL_READS_PER_SESSION 1000000
PRIVATE_SGA 10m
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LIFE_TIME 60
PASSWORD_REUSE_TIME 365
PASSWORD_REUSE_MAX 3
PASSWORD_LOCK_TIME 30
PASSWORD_GRACE_TIME 5;

Create pfile

CREATE PFILE FROM SPFILE;
CREATE PFILE='/opt/oracle/admin/mydb/pfile/initmybd.ora' FROM SPFILE='/opt/oracle/admin/mydb/pfile/spfilemybd.ora';