Oracle创建表空间以及用户语句
记录一下常用的语句，便于以后使用…
create tablespace TABLESPACENAME
datafile 'E:DataORACLEDATAXXX.dbf' size 200M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
CREATE USER USERNAME IDENTIFIED BY PASSWORD DEFAULT TABLESPACE TABLESPACENAME TEMPORARY TABLESPACE TEMP;
grant connect,resource,DBA to USERNAME ;