Re: ORA-01547 failed to allocate extent
Date: 1996/04/23
Message-ID: <4li8kf$jmn_at_soap.news.pipex.net>#1/1
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
Do you know the maximum number of extents for your system setup? EG on our HP-UX 10.01 system, the max number of extents I can allocate *ever* is 121. Maybe you are hitting that wall?
What size is the value of NEXT_EXTENT and PCT_INCREASE for the table and tablespace that your table is in? If the extent size is very large, it may have run out of filespace.
The tablespace which you are inserting the table into maybe too fragmented - if you have an analysis tool such as DBGeneral, have a look at the fragmentation that way, else you'll have to write some sql to do this. If the *tablespace* is too fragmented, then you may encounter trouble trying to find enough contiguous free space to write a new extent. From the info you've given, I'd say this was most likely to be your problem. Received on Tue Apr 23 1996 - 00:00:00 CEST