Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: ora-01536 : space quota exceeded for tablespace "INDEX"

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

From: Andrew Protasov <protasov_at_percombank.kiev.ua>
Date: Thu, 14 May 1998 16:57:50 +0300
Message-ID: <6jet91$n22$1@news.lucky.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US