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;

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

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

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