| USER TS Quotas [message #275731] |
Mon, 22 October 2007 09:31  |
dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad
|
Junior Member |
|
|
Hi..,
I 've a user called ACM_DEV which is created without mentioning the user quotas,
I 've executed the following SQL statement that, I 've got the following o/p
*****************************************************************select * from user_ts_quotas
*****************************************************************Tablespace_name Bytes Max_Bytes Blocks Dropped
*****************************************************************ACM_DEV 15859712 0 37976 NO
*****************************************************************
While creating a table I 've got the following error:
ORA-01536: space quota exceeded for tablespace 'ACM_DEV'
For this if I 've given a DBA privilege for this user am able to create the table.
But I don't want to provide that privilege, so that I 've alterred that user using the following SQL St.
Alter user ACM_DEV quota 75M on ACM_DEV
*****************************************************************Problem might be what..?
*****************************************************************Created the user without specifying the Quotas, even though why it is required to alter the user, in above case.
Is there any default Quotas, if s y that default Quota info not showin in "Max_Bytes" Column in "USER_TS_QUOTAS"
*****************************************************************
Thanks in Advance
Giri K.Y.
|
|
|
|
| Re: USER TS Quotas [message #275745 is a reply to message #275731] |
Mon, 22 October 2007 10:16  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Your quota limit is full?
And i guess your user don't have default tablespace.
you should set default tablespace for user
alter user abc default tablespace abc; |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
