Re: ORA-01547 failed to allocate extent

> 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.
>
>>>>
Extent problems I've had usually boil down to a few problems. - The NEXT parameter of the table is so small that, even though Oracle allocates the maximum permissible number of extents to the table, the total space is still insufficient for my data. - The tablespace the table is in doesn't have enough contiguous freespace for the next extent. Could either be because there isn't enough freespace period, or because it's all in little chunks each of which is smaller than NEXT.
- A growth percentage table parameter value other than 0 makes NEXT increase after each extent is allocated, until it ends up bigger than any freespace extent. For example, a value of 100% makes NEXT double in size for every extent. I keep mine set to 0. - Remember that indexes take extents too, and check for all the above problems. I've gotten into the habit of checking all of the indexes of a table at the same time I check the table when I'm having extent problems.

• Paul de Anguera, City of Seattle / HRIS