Home > ORA-XXX > ORA-01536: space quota exceeded for tablespace ‘TBS_VOIP’

ORA-01536: space quota exceeded for tablespace ‘TBS_VOIP’

1. Tonight, I got error message from the production support. They passed the message below.

ORA-01536: space quota exceeded for tablespace ‘TBS_VOIP’

2. Check user quota on the tablespace, it clearly showed that there was no quota unlimited on the tablespace TBS_VOIP ( since if there is quota unlimited on the tablespace, MAX_Bytes show -1.)

SQL> select * from user_ts_quotas;

TABLESPACE_NAME                     BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS DRO
------------------------------ ---------- ---------- ---------- ---------- ---
TBS_VOIP                        141819904          0      17312          0 NO

3. Then I granted the user with quota unlimted on the tablesapce

SQL> alter user VOIP02  quota unlimited on TBS_VOIP;

SQL> select tablespace_name, username, bytes / 1024 / 1024 “Used MB”,
2  decode(max_bytes,-1,’UNLIMITED’,max_bytes / 1024 / 1024) as “Max MB”
3  from dba_ts_quotas
4  where tablespace_name = ‘TBS_VOIP’ and username = ‘VOIP02’
5  /

TABLESPACE_NAME                USERNAME                          Used MB Max MB
—————————— —————————— ———- —————————————-
TBS_VOIP                       VOIP02                             138.25 UNLIMITED

The problem got fixed.

Advertisements
Categories: ORA-XXX
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: