--创建用户表空间
CREATE TABLESPACE icell201312
LOGGING
DATAFILE 'D:\app\xiaoli\oradata\orcl\icell201312.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--创建用户
create user dtsz identified by xiaoli_dtsz default tablespace icell201312;
--权限
grant dba, connect to dtsz
CREATE TABLESPACE icell201312
LOGGING
DATAFILE 'D:\app\xiaoli\oradata\orcl\icell201312.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--创建用户
create user dtsz identified by xiaoli_dtsz default tablespace icell201312;
--权限
grant dba, connect to dtsz