ORA-01931: cannot grant UNLIMITED TABLESPACE to a role on 10g
SQL> grant unlimited tablespace to dba_role;
grant unlimited tablespace to dba_role
*
ERROR at line 1:
ORA-01931: cannot grant UNLIMITED TABLESPACE to a role
grant unlimited tablespace to dba_role
*
ERROR at line 1:
ORA-01931: cannot grant UNLIMITED TABLESPACE to a role
The Error ORA-01931: cannot grant UNLIMITED TABLESPACE to a role is an Expected
behaviour.
This has been identified as BUG 12873187 . Until 11.1.0.7, granting UNLIMITED TABLESPACE privilege to a role raised ORA-1931 error. On 11.2, granting UNLIMITED TABLESPACE privilege
to a role succeeds, but CREATE TABLE statement still raises ORA-1950. It will be fixed in 11.2.0.4 vesion. If you need patch for 11.2.0.2 version , we need to raise a backport request.
This has been identified as BUG 12873187 . Until 11.1.0.7, granting UNLIMITED TABLESPACE privilege to a role raised ORA-1931 error. On 11.2, granting UNLIMITED TABLESPACE privilege
to a role succeeds, but CREATE TABLE statement still raises ORA-1950. It will be fixed in 11.2.0.4 vesion. If you need patch for 11.2.0.2 version , we need to raise a backport request.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21993926/viewspace-723195/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- PARALLEL_EXECUTION_MESSAGE_SIZE
- some suggestions for rac performance
- RMAN-06094 Datafile does not exist
- MRP0: Background Media Recovery terminated with error 1274
- set up a standby quickly by duplicate.
- how to mount diskgroup automatically
- alias doesn't work on solaris
- ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1]
- rac installation on Solaris10 x86-64
- How I Resolved Performance Issues After Upgrading from 9i to 10g
