table space exdtent failure

From: Tom Campbell <campbell_at_mindspring.com>
Date: 1995/05/08
Message-ID: <3ol7nj$1tng_at_nntp4.mindspring.com>#1/1


Given a separate tablespace named CUSTOMER of around 120m.

The Only table in the tablespace has its storage declared as:

   STORAGE(INITIAL 2m NEXT 2m MINEXTENTS 1 MAXEXTENTS 121    PCTINCREASE 5 FREELISTS 1 FREELIST GROUPS 1) Why would I get the following message after loading 305000+ records ??

Record 305605: Rejected - Error on table CUSTOMER. ORA-01653: unable to extend table SYSTEM.CUSTOMER by 3162 in tablespace CUSTOMER

It this point the tablespace shows

    19122 free
    101850 Used
    120972 Total

SYS.SBA_SEGMENTS shows extents as 24,max_extents as 121 and next_extent as 6475776..

Why would this fail ?

The only thing I can think of is fragmentation of some sort...

Any ideas are most welcome...
//
// campbell_at_mindspring.com DON'T PANIC
// campbell_at_peach.com
//
// My opinions may not represent those of my employer's

// (They don't know I'm Logged in )
Received on Mon May 08 1995 - 00:00:00 CEST

Original text of this message