首页 » ORACLE 9i-23ai » 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

  • 2012/04/18
  • ORACLE 9i-23ai
  • 868 views
  • 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及以后的版本不在允许。

打赏

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

上一篇：

下一篇：