docker run --name oracle19c -d -p 1521:1521 -e ORACLE_SID={SID 이름} -e ORACLE_PWD={기본 비밀번호} -e ORACLE_CHARACTERSET={캐릭터셋} doctorkirk/oracle-19c

docker run --name oracle19c -d -p 1521:1521 -e ORACLE_SID=NANOITDB -e ORACLE_PWD=sksrhd!@34 -e ORACLE_CHARACTERSET=AL32UTF8 doctorkirk/oracle-19c

CREATE USER {name} IDENTIFIED BY {비밀번호}
GRANT DBA TO {name};
GRANT ALL PRIVILEGES TO {name};

CREATE TABLESPACE {테이블스페이스이름} DATAFILE '{파일이름}' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 10 G;

CREATE TABLESPACE kpic DATAFILE 'kpic' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 10 G;

CREATE TEMPORARY TABLESPACE nanoit_temp TEMPFILE 'nanoit_temp' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 10 G;

CREATE USER post IDENTIFIED BY post DEFAULT TABLESPACE KPIC TEMPORARY TABLESPACE nanoit_temp;

CREATE USER finance IDENTIFIED BY finance
       DEFAULT   TABLESPACE KPIC
       TEMPORARY TABLESPACE KPIC_TEMP;

GRANT CREATE SESSION TO post;
GRANT CREATE SEQUENCE TO post;
GRANT CREATE TABLE TO post;
GRANT DROP ANY TO post;
GRANT UNLIMITED TABLESPACE TO post;