create tablespace data datafile '/opt/app/oracle/oradata/data.dbf'
size 50M EXTENT MANAGEMENT LOCAL;CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE '/opt/app/oracle/oradata/tmp.dbf' SIZE 5M
EXTENT MANAGEMENT LOCAL;
create tablespace index datafile '/opt/app/oracle/oradata/index.dbf'
size 50M EXTENT MANAGEMENT LOCAL;
create user star identified by star default tablespace data temporary tablespace temp;grant resource,connect,dba to star with admin option;alter user star
quota 16K on system
quota unlimited on data
quota unlimited on temp
quota unlimited on index;--退出SQLPLUS
exit;
执行到alter user star quota unlimited on temp 时报错...临时表空间不能进行配额管理么?
10g Release 2 (10.2)
Part Number B14266-01
11.1.1.4 Assigning Tablespace Quotas
You can assign each user a tablespace quota for any tablespace (except a temporary tablespace).
使用temporary tablespace的理由主要是因为它有特定的功能,这与能不能在它上面对每个用户限额有什么关系呢?