create temporary tablespace data_temp
tempfile ‘D:tablespacedata_temp.dbf‘
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create tablespace data
logging
datafile ‘D:tablespacedata.dbf‘
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create user username identified by password
default tablespace data
temporary tablespace data_temp;
grant connect,resource,dba to username;
Oracle建立用户表空间
标签：
本文系统来源：http://www.cnblogs.com/matf/p/4618602.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！