SQL Table space 생성 (OEMC에서)

1.500메가짜리 BUSANIT 테이블스페이스 생성.

 1-1. 확장자를 ora에서 dbf로 수정. 복원시 전체복원을 가능하게 한다.

CREATE SMALLFILE 

    TABLESPACE "BUSANIT" 

    LOGGING 

    DATAFILE 

    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\BUSANIT.dbf' SIZE 

    500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO 

2.자동 확장 (dbf파일명을 더블클릭)

CREATE SMALLFILE 

    TABLESPACE "BUSANIT" 

    LOGGING 

    DATAFILE 

    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\BUSANIT.dbf' SIZE 

    500M AUTOEXTEND 

    ON NEXT  1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT

    SPACE MANAGEMENT  AUTO 

3. 사용자 생성 (BUSANIT_USER // busnait_user001)

CREATE USER "BUSANIT_USER"  PROFILE "DEFAULT" 

    IDENTIFIED BY "busnait_user001" DEFAULT TABLESPACE "BUSANIT" 

    ACCOUNT UNLOCK;

GRANT "CONNECT" TO "BUSANIT_USER";

4. 권한설정 // pw 대소문자 구분 없다.

CREATE USER "BUSANIT_USER"  PROFILE "DEFAULT" 

    IDENTIFIED BY "busanit_user001" DEFAULT TABLESPACE "BUSANIT" 

    ACCOUNT UNLOCK;

GRANT CREATE CLUSTER TO "BUSANIT_USER"

GRANT CREATE DATABASE LINK TO "BUSANIT_USER"

GRANT CREATE DIMENSION TO "BUSANIT_USER"

GRANT CREATE EVALUATION CONTEXT TO "BUSANIT_USER"

GRANT CREATE EXTERNAL JOB TO "BUSANIT_USER"

GRANT CREATE INDEXTYPE TO "BUSANIT_USER"

GRANT CREATE JOB TO "BUSANIT_USER"

GRANT CREATE LIBRARY TO "BUSANIT_USER"

GRANT CREATE MATERIALIZED VIEW TO "BUSANIT_USER"

GRANT CREATE OPERATOR TO "BUSANIT_USER"

GRANT CREATE PROCEDURE TO "BUSANIT_USER"

GRANT CREATE PROFILE TO "BUSANIT_USER"

GRANT CREATE PUBLIC DATABASE LINK TO "BUSANIT_USER"

GRANT CREATE PUBLIC SYNONYM TO "BUSANIT_USER"

GRANT CREATE ROLE TO "BUSANIT_USER"

GRANT CREATE ROLLBACK SEGMENT TO "BUSANIT_USER"

GRANT CREATE RULE TO "BUSANIT_USER"

GRANT CREATE RULE SET TO "BUSANIT_USER"

GRANT CREATE SEQUENCE TO "BUSANIT_USER"

GRANT CREATE SESSION TO "BUSANIT_USER"

GRANT CREATE SYNONYM TO "BUSANIT_USER"

GRANT CREATE TABLE TO "BUSANIT_USER"

GRANT CREATE TABLESPACE TO "BUSANIT_USER"

GRANT CREATE TRIGGER TO "BUSANIT_USER"

GRANT CREATE TYPE TO "BUSANIT_USER"

GRANT CREATE USER TO "BUSANIT_USER"

GRANT CREATE VIEW TO "BUSANIT_USER"

GRANT UNLIMITED TABLESPACE TO "BUSANIT_USER"

GRANT "CONNECT" TO "BUSANIT_USER";

GRANT "DBA" TO "BUSANIT_USER";

GRANT "RESOURCE" TO "BUSANIT_USER";

5. 완료. (ITBUSAN 으로 실습한 결과)