Cause:
Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action:
1. ALTER TABLESPACE TABLESPACE_NAME ADD DATAFILE ..
2. ALTER DATABASE DATAFILE 'DATAFILE_NAME' RESIZE ..
3. COMPRESS TABLE
ALTER TABLE TABLE_NAME MOVE COMPRESS;
BULK LOAD or BULK insert
4. OLTP compress (11g)
CREATE TABLE TABLE_NAME COMPRESS FOR ALL OPERATIONS ..
5. redefine storage option (pctfree)
Is there any MORE solution?
please let me know.. :)
