[ORACLE[ 인증센터 테이블 스페이스 및 사용자 생성

CREATE TABLESPACE ts_sig_center_tbl
DATAFILE '/data2/oradata/SIG_CENTER_TBL.dbf' size 128M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED ONLINE;

CREATE TEMPORARY TABLESPACE ts_sig_center_tmp
TEMPFILE '/data2/oradata/SIG_CENTER_TMP.dbf' size 128M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

CREATE TABLESPACE ts_sig_center_idx
DATAFILE '/data2/oradata/SIG_CENTER_IDX.dbf' size 128M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED ONLINE;

CREATE USER sig_center PROFILE "DEFAULT"
IDENTIFIED BY sig_center
DEFAULT TABLESPACE ts_sig_center_tbl
TEMPORARY TABLESPACE ts_sig_center_tmp
ACCOUNT UNLOCK;

grant connect, resource to sig_center;

CREATE TABLE TBL_SERVER_KEY (
ver CHAR(8)NOT NULL,
org_strVARCHAR2(64)NOT NULL,
PRIMARY KEY (ver)
) TABLESPACE ts_sig_center_tbl;

CREATE TABLE TBL_MPCARD_INFO (
idVARCHAR2(64)NOT NULL,
pub_keyVARCHAR2(64) NOT NULL,
PRIMARY KEY (id)
) TABLESPACE ts_sig_center_tbl;