I am not a DBA but have to resolve this issue.
There are 2 permanent tablespaces in my Oracle 9i database. One for the tables and the other for the Indexes other than the Temporary and UNDO tablespaces
Last week I got the exception
ORA-01654: unable to extend index
<name of the index>by 128 in tablespace
<name of the Index tablespace>.
I got the tablespace size increased considerably. But still I am getting this error.
I deleted a lot of data thinking that would free-up some space. But that’s of no use.
Will shrinking the tablespace or re-sizing the datafiles of the permanent tablespace resolve this issue?
Also, the statistics hasn’t been gathered since March. Will gathering the latest statistics help me in any way?