Re: ORA-01654: unable to extend index

The ORA-01654 'unable to extend index DEMO.AAA_BBB by 512 in tablespace' is fairly clear. You ran out of room in the tablespace, demo_inxes, where the index is stored and freespace equal in size to the next desired extent size was unavailable.

1. You can use the alter tablespace tablespace_name add datafile 'file_name' size nnM; or
2. You might be able to alter the next extent to a smaller size that is available especially if pctincrease is not set to 0 for the index, until such time that you defrag the tablespace in question

You can use this query to check on freespace: select * from sys.dba_free_space where tablespace_name = 'DEMO_INXES' order by file_id, block_id

To see how big your index is you can look at sys.dba_segments or to see the actual allocations you can query sys.dba_extents.

I hope this information is helpful.

Stan <slc.edp_at_calberson.com.tw> wrote in article <36787724.46247AC3_at_hotmail.com>...
> Hello All,
>
> I encountered the following error messages. Can someone kindly tell me
> what I should do.
>
> ORA-06502: PL/SQL: numeric or value error
> ORA-01654: unable to extend index DEMO.AAA_BBB by 512 in tablespace
> DEMO_INXES
> ORA-06512: at "DEM
>
> Thanks in advance
>
>
>
>
Received on Thu Dec 17 1998 - 08:13:22 CST