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;