1:創建表空間 wspspace,maxsize unlimited是大小不受限制
Sql代碼
create tablespace wspspace
datafile 'D:/dev/oracle/tablespace/wspspace.dbf' size 300M
autoextend on
next 50M
maxsize unlimited
2.創建用戶
create user wsp identified by wsp default tablespace wspspace;
3.分配權限
grant connect,resource,create view to wsp;