Re: ORA-01547 failed to allocate extent
Date: 1996/04/25
Message-ID: <1996Apr25.145529.461_at_ns2>#1/1
In article <4lh120$gmm_at_dfw-ixnews5.ix.netcom.com>, hobbit_at_ix.netcom.com(. ) writes:
>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.
What you probably need to do also is dropping and re-creating your tablespace.
Because any freed extent is collected in the "list of free extents" and any
to-be-allocated extent is drawn from that list, the fragmentation of your
tablespace may result in a ORA-01547.
Dropping and re-creating your tablespace is the only solution then.
| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |
| p.j.r.vermaat_at_tfdl.agro.nl | http://gemini.tfdl.agro.nl:1024/~vermaat/ |
| Flagellant in Dreamland | ********************************************************************************Received on Thu Apr 25 1996 - 00:00:00 CEST