SQL> connect ***/***@dev
已连接。
SQL> ALTER USER zytest QUOTA UNLIMITED ON TEMP;

用户已更改。

SQL>

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE    9.2.0.8.0       Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

SQL>

C:\Documents and Settings\user>sqlplus sys/sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 5月 19 15:58:53 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> ALTER USER zytest QUOTA UNLIMITED ON TEMP;
ALTER USER zytest QUOTA UNLIMITED ON TEMP
*
第 1 行出现错误:
ORA-30041: 无法在表空间上授予限额


SQL> select * from v$version;

BANNER
--------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


为什么在9i可以，换成10g就不行呢？ 同样的一句话：ALTER USER zytest QUOTA UNLIMITED ON TEMP