| Quota exceeded! [message #138034] |
Mon, 19 September 2005 08:57  |
ankurgodambe
Messages: 45
Registered: March 2005
|
Member |
|
|
My database version is 8.1.6. If I do not set quota for a user say user1 on tablespace "A", but it has privileges to insert in a table which resides in tablespace "A", what will be the default quota for the user on this tablespace? I have got an error in my prodution saying quota exceded for user1 on tablespace A . But the table belongs to a different user who has unlimited quota on the tablespace.
Will giving unlimited tablespace to user1 help? Will this give unlimited tablespace to the user on all the tablespaces or only its default tablespace?
|
|
|
|
| Re: Quota exceeded! [message #138042 is a reply to message #138034] |
Mon, 19 September 2005 10:12  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Suppose u want to assign user1 a quota of 10M on tablespaceA.
U can do it like
SQL> Alter user user1 Quota 10M on tablespaceA;
The above command will assign user1 a quota of 10M and only on tablespaceA.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
