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

Oracle创建表空间以和用户语句，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 ;