【ORACLE】创建表空间

CREATE TABLESPACE dna36 DATAFILE 'D:\oracle\oradata\orcl\dna36.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M maxsize unlimited;
CREATE USER dna36 IDENTIFIED BY dna36 DEFAULT TABLESPACE dna36;
GRANT CONNECT, RESOURCE, CREATE VIEW TO dna36;
GRANT dba TO dna36;

posted @ 2014-07-09 10:49  hello小象  阅读(146)  评论(0)    收藏  举报