Throwing extents problem

Hello All,

A strange problem (I think)....

I have the following errors in my alert log (note the extent size):

Fri Oct 22 09:34:48 1999
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__SESSID by 704 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__SESSID by 1535 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__SESSID by 1849 in tablespace PINX00
Fri Oct 22 09:35:46 1999
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 849 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 4100 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 4100 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 1839 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 1849 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 1849 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 1849 in tablespace PINX00
ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by 1849 in tablespace PINX00

In tablespace PINX00 I have bucket loads of contiguous space:

                                    Freespace where
Tablespace     Number of extents    extent >= 16 MB     Biggest
Name                    >= 16 MB (useful freespace) free extent
-------------- ----------------- ------------------ -----------
PINX00                         1             467.67      467.67

Next extent size for this index is 4M and it has unlimited max extents.

I have manually allocated a 4M extent without error.

Why am I getting this error and why is it trying to throw an extent that doesn't match the next_extent size for this object??

Any help much appreciated.
Cheers
Tony Adolph

PS Ora 7.3.4 NT4

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 04:38:24 CDT