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;
原文：http://www.cnblogs.com/helloxiaoxiang/p/3833094.html