Stack Trace

date("Ymd-His")

간단한 것인데 찾을려면 시간 걸림 :)

-- 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

자주 까먹는 것 중에 하나