Re: New error message to me!

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 07 Jul 1999 12:20:58 -0400
Message-ID: <37837E6A.977F3589@Unforgettable.com>

Check the table storage parameters to see if you are trying to grab a NEXT extent that is larger than the remaining space in the tablespace. Also, take a look at the table in DBA_EXTENTS and pay particular attention to the number of bytes in each successive extent.

Ken

Terry Maguire wrote:

> Hi all
>
> I'm using Oracle 7.3.3 and the Oracle SQL Worksheet app to modify a few
> tables. When I execute the following statement to transfer data:
>
> insert into t_daily_download
> select * from download
> where to_char(downloaddate)='29-JAN-99'
>
> I get the following error message:
>
> ORA-01653: unable to extend table TERRY.T_DAILY_DOWNLOAD by 61446 in
> tablespace QUANTBCK
>
> There are no problems with the size of tablespace, there's loads of free
> space. I checked Dejanews and saw info on coalescing. I checked and there's
> no prob there. So if anyone has any idea what this is please reply.
>
> Regards
>
> Terry Maguire
Received on Wed Jul 07 1999 - 11:20:58 CDT