Re: HELP: ora-01536 : space quota exceeded for tablespace "INDEX"

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 14 May 1998 07:20:56 GMT
Message-ID: <01bd7f08$d18b86d0$47c3657e@polcar_nt4006>

Hi,
check the current storage parameters for the authorization table. It might be that the NEXT extent
is too large.
Regards,

--
Pavel Polcar

Husamt <husamt_at_aol.com> wrote in article <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 - 02:20:56 CDT