Re: ORA-01547 failed to allocate extent

You described your problem as repeated ORA-01547 errors on a specific table even after export/import when you do not have very many records..

Sounds like you might have a small initial and next allocation setting on the table. This happens when you accept the tablespace storage defaults rather than size the table. I suggest that you check the parameters in the dictionary table: sys.dba_tables for the initial and next entries. You might have a very large next extent set up that exceeds the availalbe free space in the tablespace. Also if there is room for a next remember that if pctincrease is not zero then it will be increased by this percentage, ie, 50% results in 1.5 * the next value worth of space being requested.

I hope this helps.

Mark Powell -- No witty disclaimer

Export the table, reallocate the table with proper entries, and then import the data. Also check sys.dba_data_files to see how many and how large the files that make up the tablespace are. I once made a typo and added a 256 megabyte file as just 256 and Oracle added a 256 character file to the tablespace. A tablespace map showed Oracle then took 8K out of this for its file header block and naturally refused to allocate an extent into this space.
.. Received on Tue Apr 23 1996 - 00:00:00 CEST