CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Error - ORA-01654 unable to extend index by 128 in tablespace

This page deals with the following error

SQL Error: ORA-01654:unable to extend index CAST_KB.FUSACC_IDFUS by 128 in tablespace.

SQL Error:ORA-06512: at “CAST_KB.INT_I_F_ACC”. Line 181

SQL Error: ORA-06512 : at “CAST_KB.I_TB_ACC”,line 17

"Error with saving manager"

The error ‘unable to extend index’ is produced in the case where there is no more free space in the tablespace that contains the knowledge base:
Therefore, you need to allocate free space to the concerned tablespace and re-run the analysis.

1. Use the following query to check for the tablespace space:

   SELECT
   a.TABLESPACE_NAME,
   a.BYTES bytes_used,
   b.BYTES bytes_free,
   b.largest,
   round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used
   FROM
   (
   select TABLESPACE_NAME,
   sum(BYTES) BYTES
   FROM dba_data_files
   group by TABLESPACE_NAME
   )
   a,
   (
   select TABLESPACE_NAME,
   sum(BYTES) BYTES ,
   max(BYTES) largest
   FROM dba_free_space
   group by TABLESPACE_NAME
   )
   b
   where a.TABLESPACE_NAME=b.TABLESPACE_NAME
   and a.TABLESPACE_NAME= ‘PAS_NEW_STAGE_KB_PRDREL’
   order by ((a.BYTES-b.BYTES)/a.BYTES) desc;

2. If Percent Used is more than 85% then regarding to Oracle, this is not a good setting. Further, according to the size of your base, it is safer to have at least 1GB or more of available space.
   Therefore, please check with your DBA to increase the available free space.
3. If autoextend is enabled:
   Enabling the Autoextend is an appropriate scenario. But note that this is not sufficient as the tablespace setting relies also on the max size. The autoextend will be done until the max size is reached. Therefore, you need to ensure that you have enough free space on your tablespace to manage analysis done in your knowledge base.
   Please refers to pages 124 and 125 of the CAST installation Guide
4. You can also increase the according to number of objects in KB.To know the total number of objects available in your knowledge base, connect to Server Manager, right click on the knowledge base and generate a Diagnostic report. In this report, you will have the total number of objects. With this number and by approximation, you can know the free space you need on your tablespace.