Xref: alice comp.databases.oracle.misc:35544
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!news-out.worldnet.att.net.MISMATCH!wn3feed!worldnet.att.net!207.24.196.41!nntphub.cb.lucent.com!news
From: Kenneth C Stahl <BluesSax@Unforgettable.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: New error message to me!
Date: Wed, 07 Jul 1999 12:20:58 -0400
Organization: Xyzzy Plugh Plover
Lines: 31
Message-ID: <37837E6A.977F3589@Unforgettable.com>
References: <7lvtg1$o5g$1@ezekiel.eunet.ie>
Reply-To: BluesSax@Unforgettable.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.51 [en] (Win95; U)
X-Accept-Language: en-US,en

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