Oracle创建表空间以和用户语句

记录一下常用的语句，便于以后使用…

create tablespace tablespacename

datafile ‘e:\data\oracledata\xxx.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 ;