본문 바로가기
Dev./Back-end

SQL Table space 생성 (OEMC에서)

by 돌도르 2012. 10. 4.
728x90


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 으로 실습한 결과)


'Dev. > Back-end' 카테고리의 다른 글

Oracle 연습문제 2~7장  (1) 2012.10.14
Ubuntu 12.04(x86) 에 Oracle11g Tomcat7 JDK1.7 Eclipse 깔기.  (0) 2012.10.04
20120925 Oracle  (0) 2012.09.25
Oracle 연습문제 . 데이터입력  (0) 2012.09.24
/*Over(partition by)*/ /*inner query*/  (0) 2012.09.24

댓글