table space exdtent failure
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