首页 » ORACLE » in version 10.2 oracle does not support quota on temporary tablespaces,ora-30041

in version 10.2 oracle does not support quota on temporary tablespaces,ora-30041

今天看到有人问填加用户报ora-30041

[oracle@ora10g ~]$ oerr ora 30041
30041, 00000, “Cannot grant quota on the tablespace”
// *Cause: User tried to grant quota on an undo or temporary tablespace
// *Action: Check the tablespace name and reissue the command

e.g.

SQL> ALTER USER INDIA QUOTA 4M ON TEMP;
ALTER USER INDIA QUOTA 4M ON TEMP
*
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace


Cause of the Problem:
--------------------------
This is expected behavior in oracle 10.2g. In version 10.2 oracle does not support quota on temporary tablespaces.

If your version is earlier than 10.2g then this is a bug.

Solution of The problem:
--------------------------------
Don't try to assign quota on the temporary tablespaces if your database version is 10.2 as it is expected behavior.

note:
如果在10gr1及以前的版本,在temp tablespace设quota是可以的,但真正的不应该在temp 上设限额,本身就是一个bug,在10gr2中被修复,所以10gr2及以后的版本不在允许。

打赏

对不起,这篇文章暂时关闭评论。