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;