Oracle创建用户及表空间 代码片段

create tablespace testdata
logging
datafile 'D:\oracle\oradata\orcl\testdata.dbf'
size 50m
autoextend on
next 100m maxsize 20480m
extent management local;

create user test identified by test
default tablespace testdata
temporary tablespace temp;

grant connect,resource,dba to test;

转载于:https://www.cnblogs.com/tmeily/p/4273227.html