Re: help with error...

From: <oratune_at_aol.com>
Date: Thu, 26 Oct 2000 13:24:03 GMT
Message-ID: <8t9b9a$dfn$1@nnrp1.deja.com>

In article <39f80c4e_at_news.iprimus.com.au>,   "Howard J. Rogers" <howardjr_at_www.com> wrote:
> 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.
>
>

Also try 'ALTER TABLESPACE ... COALESCE' to coalesce any fragmented free space. Free space fragments that are too small for the desired segment can also create this error.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Thu Oct 26 2000 - 08:24:03 CDT