Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: ora-01536 : space quota exceeded for tablespace "INDEX"
Hi,
I saw this with Oracle 7.2. Try to set users's quota not unlimited but some big number, say 1000m. It works for me. It seems that 1000m>unlimited for Oracle 7.2.
Andrew Protasov
Husamt wrote in message <1998051322211400.SAA16255_at_ladder01.news.aol.com>...
>
>I get this error when a user try to insert a record on a specific table
>(authorization table) even though the oracle user has UNLIMITED space
quota.
>
>If the user insert a different record in another major table , we are not
>getting this problem. Only with that particular table (Authorization).
>
>I've checked space on the tablespace to find a plenty of it (1/2 full). I
>doubled checked with dba_ts_quotas to find the user already been granted
>Unlimited (-1).
>
>Any thoughts on this.. Thanks.
Received on Thu May 14 1998 - 08:57:50 CDT