Stack Trace

-- Create Data File
CREATE TABLESPACE oracle_DATA
    DATAFILE '/app/oracle/oradata/oracle_data.dbf' size 2000M AUTOEXTEND ON NEXT 500M
    EXTENT MANAGEMENT LOCAL                                                                            
        SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE oracle_IDX
    DATAFILE '/app/oracle/oradata/oracle_idx.dbf' size 1500M AUTOEXTEND ON NEXT 200M
    EXTENT MANAGEMENT LOCAL                                                                            
    SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE oracle_LOB
    DATAFILE '/app/oracle/oradata/oracle_lob.dbf' size 2000M AUTOEXTEND ON NEXT 500M
    EXTENT MANAGEMENT LOCAL                                                                            
    SEGMENT SPACE MANAGEMENT AUTO;

-- Create User
CREATE USER project identified BY projectION
DEFAULT tablespace oracle_DATA
TEMPORARY tablespace TEMP
profile DEFAULT QUOTA unlimited On oracle_DATA;

alter user project quota unlimited on oracle_LOB;
alter user project quota unlimited on oracle_IDX;

GRANT CONNECT TO project;
GRANT resource TO project;
GRANT DBA TO project;
GRANT Unlimited tablespace TO project;
GRANT CREATE ANY INDEX, CREATE DATABASE LINK, CREATE PUBLIC DATABASE LINK, GLOBAL QUERY REWRITE, QUERY REWRITE TO project;

commit;

#! /bin/bash
/usr/bin/rdate -s time.bora.net && /sbin/clock –w

자주 까먹는 것 중에 하나

impdp ics6/asdf DUMPFILE=ics6.dmpdp SCHEMAS=ics6

expdp ics6/asdf DUMPFILE=ics6.dmpdp SCHEMAS=ics6

imp ics6/asdf file='ics6.dmp' fromuser=ics6 touser=ics6

exp ics6/asdf file='ics6.dmp' STATISTICS=NONE

간단한 건데 왜 매일 까먹을까?

-- Java Install

wget http://download.oracle.com/otn-pub/java/jdk/6u29-b11/jdk-6u29-linux-x64-rpm.bin
chmod -c 744 ./jdk-6u29-linux-x64-rpm.bin
./jdk-6u29-linux-x64-rpm.bin

-- Java Home Setting

vi /etc/profile
export JAVA_HOME=/usr/java/default
export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH=$JAVA_HOME/jre/lib:$JAVA_HOME/lib/tools.jar

Install Oracle (T.T) JDK 6

SELECT t1.apprid,
  t1.ruletypecd,
  t2.catid
FROM user_approval_tblc t1,
  user_authority_tblc t2
WHERE t1.apprid   = 942
AND t1.userauthid = t2.userauthid ;

for V5, find category by Approval rule ID