Oracle 创建表空间与用户

1.表空间创建

create tablespace piccehr 
datafile 'E:\E-HR实施\PICC\00TableSpace\picc01.dbf'
size 10m
autoextend on;

2.用户创建

create user tb4s
identified by "tb4s"
default tablespace piccehr;

3.用户授权

grant dba,connect,resource to tb4s;