DB 생성

-- 테이블스페이스 정보 조회
select * from dba_data_files;

-- 유저정보 조회
SELECT USERNAME, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE FROM DBA_USERS;

-- 사이트1

CREATE TABLESPACE UL_W
 datafile '/oradata/UL/UL_W.dbf' size 1024M
 AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
 DEFAULT STORAGE (INITIAL 50K
  NEXT 50K
  MINEXTENTS 10
  MAXEXTENTS 121
  PCTINCREASE 50);

-- 사이트2
CREATE TABLESPACE YUL_LIB
 datafile '/oradata/UL/UL_LIB.dbf' size 500M
 AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
 DEFAULT STORAGE (INITIAL 50K
  NEXT 50K
  MINEXTENTS 10
  MAXEXTENTS 121
  PCTINCREASE 50);
  
-- 사이트1 이용자
CREATE USER UL_W

 IDENTIFIED BY W_PASS
 DEFAULT TABLESPACE UL_W
 PROFILE DEFAULT;

GRANT CONNECT, DBA TO UL_LIB;

-- 사이트2 이용자
CREATE USER UL_LIB
 IDENTIFIED BY L_PASS
 DEFAULT TABLESPACE L_LIB
 PROFILE DEFAULT;

GRANT CONNECT, DBA TO L_LIB;

CREATE TABLESPACE L_TS
 datafile '/oradata/UL/Y.dbf' size 1024M
 AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
 DEFAULT STORAGE (INITIAL 50K
  NEXT 50K
  MINEXTENTS 10
  MAXEXTENTS 121
  PCTINCREASE 50);

CREATE USER yuser
 IDENTIFIED BY gpassword
 DEFAULT TABLESPACE L_TS
 PROFILE DEFAULT;

GRANT CONNECT, DBA TO yuser;