Window) Oracle Table Space 설정 방법

Window 에 설치된 오라클에 테이블 스페이스를 잡아보았다! 

 

* MYTESTSPACE와 adminGenie 는 내가 정한 이름이니 본인에 맞게 수정 후 사용하기! 

 

 

1. CMD로 DB 서버 접속 

오라클 접속 
sqlplus "/as sysdba"

2. 스페이스 생성 
create tablespace MYTESTSPACE datafile 
'C:\app\Administrator\oradata\orcl\MYTESTSPACE .DBF' size 2048M autoextend on next 100M
maxsize unlimited;

3. 잘생성되었는지 확인 
- SELECT * FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'MYTESTSPACE' 

4. 유저생성
create user adminGenie
identified by test1234
default tablespace MYTESTSPACE ;


5. 권한부여
GRANT UNLIMITED TABLESPACE TO adminGenie
GRANT SELECT ANY TABLE TO adminGenie 
GRANT CREATE TABLE TO adminGenie 
GRANT UPDATE ANY TABLE TO adminGenie 
GRANT CREATE TRIGGER TO adminGenie 
GRANT DROP PUBLIC DATABASE LINK TO adminGenie  
GRANT DELETE ANY TABLE TO adminGenie 
GRANT CREATE ANY TABLE TO adminGenie  
GRANT INSERT ANY TABLE TO adminGenie  
GRANT CREATE VIEW TO adminGenie 
GRANT CREATE SEQUENCE TO adminGenie 
GRANT CREATE PUBLIC DATABASE LINK TO adminGenie 
GRANT ALTER SESSION TO adminGenie 
GRANT CREATE SESSION TO adminGenie 
Grant connect,resource,alter session to adminGenie