1.创建临时表空间
create temporary tablespace appstemptsp tempfile ‘/oracle/app/oracle/oradata/orcl/appstemp01.dbf‘ size 32m autoextend on next 32m maxsize 2048m extent management local;
2.创建表空间
create tablespace appstsp logging datafile ‘/oracle/app/oracle/oradata/orcl/apps01.dbf‘ size 32m autoextend on next 32m maxsize 2048m extent management local;
3.创建用户并指定表空间
create user apps identified by apps default tablespace appstsp temporary tablespace appstemptsp;
4.给用户赋权
grant connect,resource,dba to apps;
原文：http://www.cnblogs.com/wolil/p/5564827.html