Re: ORA-01547 failed to allocate extent

In article <4lh120$gmm_at_dfw-ixnews5.ix.netcom.com>, . <hobbit_at_ix.netcom.com> wrote:
>Started getting this error on a table with only a few thousand entries.
>Have created another tablespace for temp segments, done the ADD
>DATAFILE, and done all that the manuals suggest for defragmenting.
>Exported data, dropped and recreated table and re-imported data and
>this worked for about a day and a half. PLEASE HELP ME. Oracle Helpdesk
>was not speaking my language. Error occurs when doing a table update.
>Error indicates Failing to Allocate Extents. Using WARP Connect and
>Oracle version 7.
>Any advice would be greatly appreciated.
>

have you checked:

   select tablespace_name, sum(bytes) from dba_free_space    group by tablespace_name
   ;

to see if there's actually room left on this tablespace ?

How many extents are there in the table ?    

   select extents from user_segments where segment_name = 'TABLE_NAME';    (where TABLE_NAME is the table you have trouble with)

  Depending on your OS and DB_BLOCK_SIZE , this can be a maximum of   121, or 249 or so.

Finally, could it be an index on this table, stored on a different tablespace, which is actually bottlenecking? The free_space query above will show that.

Hope it helps,

Kevin Fries

-- 
-------------------------------------------------------------
Kevin Fries                         kelfink_at_ecst.csuchico.edu
CPD/PB, C Developer/DBA  http://www.ecst.csuchico.edu/~kelfink