//创建临时表空间,如果已经有,就不需要创建
create TEMPORARY TABLESPACE TEMPTS01 tempfile 'C:/oracle/product/10.2.0/oradata/orcl/TEMPTS01.DBF' size 100M;
//创建用户
CREATE USER xuebin IDENTIFIED BY xuebin
PROFILE DEFAULT
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMPTS01
ACCOUNT UNLOCK;
grant RESOURCE to xuebin;
grant connect to xuebin;