引用自http://www.cnblogs.com/GoalRyan/archive/0001/01/01/1525055.html
创建临时表空间
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'F:\oracle\product\10.2.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL
创建用户表空间
CREATE TABLESPACE test_data
LOGGING
DATAFILE 'F:\oracle\product\10.2.0\oradata\orcl\TEST_DATA01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL
创建用户并制定表空间
CREATE USER yiq IDENTIFIED BY yiq
DEFAULT TABLESPACE TEST_DATA
TEMPORARY TABLESPACE TEST_TEMP
给用户授予权限
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO username;