Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01654
Could free space fragmentation be the problem?
I've seen this happen when there is plenty of free space available but none of the fragments are large enough to accommodate the next extent. This can happen if there is a lot of deletion going on in the relevant tablespace. Space in the data files gets fragmented over time just like space on a disk drive.
The problem can be resolved using the exp tool with the compress extents option.
Best wishes,
Richard
"jeff" <jgoodman999_at_mail.com> wrote in message
news:a076cb64.0309080837.24224c85_at_posting.google.com...
> I am getting the message ORA-01654: unable to extend index
> VAR.VARINDEX_INSTRUMENTPNL_2 by 138254 in tablespace INDEXES when
> inserting rows in my table. My DBA tells me that I have more than
> enough free space. Is there anything else he can look at (I dont have
> a lot of faith in his ability.) Any other ideas would be great.
Received on Mon Sep 08 2003 - 13:51:04 CDT