1. 创建临时表空间 create temporary tablespace documentTEMP tempfile 'D:/app/oradata/orcl/documentTEMP.dbf' size 500m autoextend on next 100m maxsize 10240m extent management local; 2. 创建数据表空间 create tablespace documentmain datafile 'D:/app/oradata/orcl/documentmain.dbf' size 500M autoextend on next 50M maxsize unlimited extent management local; 3.创建用户并制定临时表空间和默认表空间 create user documentuser identified by documentuserdefault tablespace documentmaintemporary tablespace documentTEMP;4.给用户授予权限 grant connect,resource,dba to documentuser;