DB/Oracle

테이블 스페이스 생성

hyuni. 2012. 9. 25. 17:47

CREATE TABLESPACE TS_BTS
DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\EFUSIONI\TS_BTS.DBF' SIZE 100M;


CREATE USER BTS IDENTIFIED BY BTS DEFAULT TABLESPACE ts_bts;

GRANT UNLIMITED TABLESPACE to bts;

GRANT CONNECT, RESOURCE, CREATE VIEW, DBA TO bts;