Re: help with error...

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 26 Oct 2000 21:48:31 +1000
Message-ID: <39f80c4e@news.iprimus.com.au>

Just a wild stab in the dark, but there aren't any quotas in use, are there??

The owner of the table is still subject to quotas, even if the extension of the table is occasioned by inserts or updates done by totally innocent third parties. Find out who owns the table, then 'alter user X quota unlimited on <relevant tablespace>' and see if that fixes the problem. If it does, you know where to fine tune things.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

<gdas_at_my-deja.com> wrote in message news:8t7sqv$a7s$1_at_nnrp1.deja.com...


> In article <8t7rn1$9fv$1_at_nnrp1.deja.com>,

>   EnderW <ender29_at_my-deja.com> wrote:

> > What are the next_extent and maxetents for the table and the

> > tablespace ?

>

> The next_extent and maxextents on the tablespace are: 10240 and 121

> respectively.

>

> The next_extent and maxextents on the table are:  283144192 and 121

>

> respectively.  I'm new to this, so can you let me know if this provides

> a clue?

>

> Thanks,

> Gavin

>

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Thu Oct 26 2000 - 06:48:31 CDT