导读: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 defau...
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;