登录数据库SYSDBA用户：
创建用户CESHI
–说明：替换所有CESHI为要创建的用户，修改密码为要使用的密码；
–创建用户默认表空间
CREATE TABLESPACE “CESHI01_DATA”
DATAFILE ‘CESHI_DATA_01.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
‘CESHI_DATA_02.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
–创建用户索引表空间
CREATE TABLESPACE “CESHI02_INDEX” DATAFILE
‘CESHI_INDEX_01.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
‘CESHI_INDEX_02.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
–创建用户
CREATE USER “CESHI” IDENTIFIED BY “密码” PASSWORD_POLICY 0
DEFAULT TABLESPACE “CESHI01_DATA”
DEFAULT INDEX TABLESPACE “CESHI02_INDEX”;

GRANT “PUBLIC”,“RESOURCE”,“SOI”,“SVI”,“VTI” TO “CESHI”;