oracle 创建一个用户并指定默认表空间和临时表空间 1. 创建临时表空间 SQL> create temporary tablespace test1temp tempfile '/home/u01/app/oracle/oradata/ytzx/test1temp01.dbf' size 10240m autoextend on next 1024m maxsize 20480m extent management local ; 2. 创建数据表空间 SQL> create tablespace test1 logging datafile '/home/u01/app/oracle/oradata/ytzx/test1.dbf' size 10240M --50-100G autoextend on next 2000M maxsize unlimited extent management local autoallocate segment space management auto ; 3.创建用户并制定临时表空间和默认表空间 SQL>create user test1 identified by test1 default tablespace test1 temporary tablespace test1temp; 4.给用户授予权限 grant connect,resource to test;