| Temporary Tablespace Group [message #166227] |
Wed, 05 April 2006 05:06  |
AlinaC
Messages: 45
Registered: November 2005
Location: India
|
Member |
|
|
I was trying to allocate unlimited quota to a user on temporary tablespace (Oracle10G Rel2) , but it didn’t allow to do so. Is it new to Oracle10G? if I create a temporary tablespace group how much quota an user can get ? is it unlimited?
Regards,
Alina
|
|
|
|
| Re: Temporary Tablespace Group [message #166293 is a reply to message #166227] |
Wed, 05 April 2006 09:48  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
You don't need to assign users a quota on the temporary tablespace. In fact, prior releases allowed it, but it was never enforced. So, maybe you should rather see it as a bug that is now fixed in 10.2.
SQL> alter user scott quota unlimited on temp;
alter user scott quota unlimited on temp
*
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
