CREATE TABLESPACE "用户名01_DATA"
DATAFILE '用户名_DATA_01.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
'用户名_DATA_02.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
--创建用户索引表空间
CREATE TABLESPACE "用户名02_INDEX" DATAFILE
'用户名_INDEX_01.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
'用户名_INDEX_02.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
--创建用户
CREATE USER "用户名" IDENTIFIED BY "用户名123456" PASSWORD_POLICY 0
DEFAULT TABLESPACE "用户名01_DATA"
DEFAULT INDEX TABLESPACE "用户名02_INDEX";
GRANT "PUBLIC","RESOURCE","SOI","SVI","VTI" TO "用户名";