TABLESPACE 및 USER 생성 스크립트

- TABLESPACE

# Windows
DROP TABLESPACE koras INCLUDING CONTENTS
CREATE TABLESPACE koras
    DATAFILE 'C:\oracle\product\10.2.0\oradata\orcl\koras.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M
    DEFAULT STORAGE
                (INITIAL     10K
                 NEXT        10K
                 MINEXTENTS  2
                 MAXEXTENTS  50
                 PCTINCREASE 50)

# Linux
DROP TABLESPACE trackview INCLUDING CONTENTS
CREATE TABLESPACE trackview
    DATAFILE '/opt/oracle/product/10.2.0/oradata/trackview.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M
    DEFAULT STORAGE
                (INITIAL     10K
                 NEXT        10K
                 MINEXTENTS  2
                 MAXEXTENTS  50
                 PCTINCREASE 50)


- USER

DROP USER koras CASCADE;
CREATE USER koras IDENTIFIED BY koras#123
    DEFAULT TABLESPACE koras
    TEMPORARY TABLESPACE temp;

GRANT CONNECT, RESOURCE, DBA TO koras;