文档解释
ORA-30041: 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
ORA-30041: Cannot grant quota on the tablespace错误是因为试图给表空间赋予配额失败所导致的。
官方解释
ORA-30041: Cannot grant quota on the specified tablespace
Cause: A failed attempt was made to grant a quota on the specified tablespace.
Action: Check that the tablespace is either not read-only or is set to be managed by the same user who is attempting to grant the quota, and that the quota is valid before retrying the operation.
常见案例
通常情况下，会在用户创建表空间时，就会指定一定配额，授予用户以此表空间的使用权限，但有时用户会试图对已有的表空间添加更多的配额，而不是直接去指定配额，而这时则会出现ORA-30041的错误。
一般处理方法及步骤
1.检查是否表空间是否只读，或者是否由同一个用户管理。
2.检查用户是否有授予向表空间配额的权限。
3.检查表空间配额是否有效。
4.如果表空间有效并且权限正确，则重新执行尝试授予配额的操作。
