[Oracle] DB schema & account create query

Oracle SQL Plus 로 schema 생성하는 query

-- UMP_CORE Tablespace create. CREATE TABLESPACE UMP_CORE     DATAFILE 'UMP_CORE.dbf' SIZE 500M     DEFAULT STORAGE     (INITIAL 10K     NEXT 10K     MINEXTENTS 2     MAXEXTENTS 50     PCTINCREASE 50); create user UMPCORE identified by UMP000 default tablespace UMP_CORE; grant connect, resource, create view, create procedure, create sequence to  UMPCORE; commit; -- UMP_SA Tablespace create. CREATE TABLESPACE UMP_SA     DATAFILE 'UMP_SA.dbf' SIZE 5000M     DEFAULT STORAGE     (INITIAL 10K     NEXT 10K     MINEXTENTS 2     MAXEXTENTS 50     PCTINCREASE 50); create user UMPSA identified by UMP000 default tablespace UMP_SA; grant connect, resource, create view, create procedure, create sequence to  UMPSA; commit;