Re: help with error...

What are the next_extent and maxetents for the table and the tablespace ?

In article <8t7rab$93e$1_at_nnrp1.deja.com>,

  gdas_at_my-deja.com wrote:
> Hi,
>
> Our application is getting the error 01653, to extend table REXCPT by
> 77772 in tablespace USERS.
>
> I monitor all the tablespaces regularly, twice a day so I didn't
> believe the tablespace could have been out of space. I checked the
> users tablespace using sys.dba_free_space and it shows 2 Gigs free.
>
> So then I tried extending the tablespace anyway. I added more
> datafiles which brought the amount of freespace up to 4 gigs.
 However,
> this error still comes up.
>
> Does anyone know what has happened?
>
> Thanks for any help,
> Gavin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Ender Wiggin


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