Re: help with error...

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 26 Oct 2000 14:11:31 +0100
Message-ID: <8t9ai5$cp5$1@soap.pipex.net>

Looks like the table was created with 50% or greater extent growth

283144192 is 200 odd meg by my calculation. This would have to be contiguous so a couple of things to check

Can you extend if you coalesce the free space 'ALTER TABLESPACE USERS COALESCE;'.
How large are each of your datafiles? Can the next entent actually fit in any single datafile?

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<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 - 08:11:31 CDT