| User | Post |
|
11:36 pm
June 27, 2009
|
Bangladesh
Member
| | | |
|
| posts 14 |
|
|
Hi, we are facing the below problem in live application
ORA-01536: space quota exceeded for tablespace 'MON_TBS'.
May be this problem is coming for other tablespace like 'DATA3'. I saw this tablespace has enough free space. I checked it from dba_free_space
Also rollback segment and temporary tablespace is almost 99% full.
Please Can anyone help us?
Thanks in advance.
|
|
|
2:20 am
June 28, 2009
|
halim
Member
| | Dhaka | |
|
| posts 36 |
|
|
Increase the size of tablespace 'MON_TBS'.
i think it solve your problem.
if its have enough space then increase the quota amount for your
log in user on tablespace 'MON_TBS'.
regards
Halim
|
|
|
|
|
2:42 pm
June 29, 2009
|
ddfdba
Moderator
| | | |
|
| posts 931 |
|
|
Post edited 1:28 pm – July 7, 2009 by ddfdba
Bangladesh said:
Hi, we are facing the below problem in live application
ORA-01536: space quota exceeded for tablespace 'MON_TBS'.
May be this problem is coming for other tablespace like 'DATA3'. I saw this tablespace has enough free space. I checked it from dba_free_space
Also rollback segment and temporary tablespace is almost 99% full.
Please Can anyone help us?
Thanks in advance.
The error text is clearly stating the problem:
ORA-01536: space quota exceeded for tablespace 'MON_TBS'.
The connected user has exceeded his/her quota for the MON_TBS tablespace. The solution is to increase the quota for the affected user. Adding space to the tablespace won't fix this problem.
David Fitzjarrell
|
|
|
|
|
12:19 am
June 30, 2009
|
Arju
Moderator
| | | |
|
| posts 132 |
|
|
It is good to know that if quota is exhausted on dependent objects then the same error occured. So if you think the connected user quota is exhausted then it is wrong. The dependent user's quota might be needed to increase then.
I have made an example in http://arjudba.blogspot.com/20…..haust.html
|
|
|
9:09 am
June 30, 2009
|
ddfdba
Moderator
| | | |
|
| posts 931 |
|
|
Arju said:
It is good to know that if quota is exhausted on dependent objects then the same error occured. So if you think the connected user quota is exhausted then it is wrong. The dependent user's quota might be needed to increase then.
I have made an example in http://arjudba.blogspot.com/20…..haust.html
Yet your 'example' doesn't cover this question as no trigger or other user id is reported (granted the original poster may have not posted all relevant information). Check your example again and you'll see the owner is clearly reported in the error text:
ORA-01536: space quota exceeded for tablespace 'USERS'
ORA-06512: at “TEST2.T”, line 2
ORA-04088: error during execution of trigger 'TEST2.T'
Clearly this is an issue with the quota assigned to the TEST2 user for the USERS tablespace. When the original poster provides more information on this situation a correct assessment can be made and the proper solution offered.
David Fitzjarrell
|
|
|
|
|
9:51 am
June 30, 2009
|
Arju
Moderator
| | | |
|
| posts 132 |
|
|
Fully agree. I just mentioned about the scenarios and made an example.
|
|
Forums
