// 컬럼 암호화 CREATE SEQUENCE “ESVALI_TECH”.”ING_SEQ_2″ NOCACHE  lock TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ IN EXCLUSIVE MODE  ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ADD ing_row_id INTEGER UPDATE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ SET    ing_row_id=”ESVALI_TECH”.ing_seq_2.NEXTVAL WHERE  ROWID=ROWID CREATE UNIQUE INDEX “ESVALI_TECH”.ing_idx_2 ON “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ( ing_row_id ) LOCK TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ IN EXCLUSIVE MODE ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ADD ( “ISSUE_NEW” RAW(528) ) ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ RENAME TO “TB_TECH_HISTORY_HASU0707_NEW” CREATE OR replace VIEW “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV” AS SELECT “INDEX”,        “DATE”,        “CUSTOMER”,        “PRODUCT”,        “VERSION”,        “ISSUE”,        “PROCESS”,        “ETC”,        “ING_ROW_ID” FROM   “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_NEW” CREATE OR replace VIEW “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ AS SELECT “INDEX” ,        “DATE” ,        “CUSTOMER” ,        “PRODUCT” ,        “VERSION” ,        “ISSUE” ,        “PROCESS” ,        “ETC” FROM   “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV”  CREATE OR replace TRIGGER “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0_INS_TRIG” instead OF  INSERT ON “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV” REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE check_22 VARCHAR2         (               512        );BEGIN   SELECT :NEW.”ISSUE”   INTO   check_22   FROM   dual;      INSERT INTO “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_NEW”               (                           “INDEX”,                           “DATE”,                           “CUSTOMER”,                           “PRODUCT”,                           “VERSION”, […]

1. INGRIAN 계정 생성 # Oracle 관리자 접속 sqlplus sys/비밀번호 as sysdba REM 테이블 스페이스 생성 CREATE TABLESPACE ts_ingrian DATAFILE ‘/oradata/orcl/ingrian.dbf’ SIZE 2M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE; REM 계정 생성 CREATE USER ingrian IDENTIFIED BY “비밀번호”; REM 테이블 스페이스 할당 ALTER USER ingrian DEFAULT TABLESPACE ts_ingrian; REM temp 테이블 스페이스 할당 ALTER USER

/xe/index.php?mid=linux&document_srl=4025 를 참조하여 리눅스 설치 후… yum -y install libaio yum -y install libaio-devel yum -y install libgcc yum -y install libstdc++ yum -y install sysstat yum -y install unixODBC yum -y install unixODBC-devel