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