//创建临时表空间?

create temporary tablespace tpts_temp?
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\tpts_temp01.dbf'?
size 32m?
autoextend on?
next 32m maxsize 2048m?
extent management local;?

//创建数据表空间?
create tablespace ts_name?
logging?
datafile 'D:\oracle\product\10.2.0\oradata\orcl\ts_name01.dbf'?
size 32m?
autoextend on?
next 32m maxsize 2048m?
extent management local;?

//创建用户并指定表空间?
create user username identified by password?
default tablespace? ts_name??
temporary tablespace tpts_temp;?

//给用户授予权限?

grant connect,resource to username;?