1 minutes readIssue: ORA-08104: this index object 14944 is being online built or rebuilt

Anup October 5, 2023

0 Comments

Reader Mode

Issue:
SQL> ALTER INDEX GTUSER.INDX_PCD_CHARGING_ID REBUILD online NOLOGGING parallel 16;
ALTER INDEX GTUSER.INDX_PCD_CHARGING_ID REBUILD online NOLOGGING parallel 16
*
ERROR at line 1:
ORA-08104: this index object 14944 is being online built or rebuilt

Soultion:

1. Firstly check the object_id if it exists.SQL> select obj# ,name from obj$ where OBJ#=14944;

OBJ# NAME
———- ——————————
14944 INDX_PCD_CHARGING_ID

2. Invoke Clean index function (This function performs a manual cleanup of failed or interrupted online index builds or rebuilds)

declare
msd BOOLEAN;
begin
msd := dbms_repair.online_index_clean(14944);
end;
/

3. Rebuild Again

ALTER INDEX GTUSER.INDX_PCD_CHARGING_ID REBUILD online NOLOGGING parallel 16;

Post Views: 105

Categories: Blog, Others

ORA-08104: this index object 229469 is being online built or rebuilt

Reader ModeWhile rebuilding an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair Problem: SQL> alter index sapr3.”ZJDADEMAND~0″ rebuild…

Anup October 5, 2023

0 Comments

Type of RMAN Backup Tutorial

Reader Mode Full Backups A full backup reads the entire file and copies all blocks into the backup set, only skipping datafile blocks that have…

Anup June 13, 2009

0 Comments

How to Move OCR and Voting Disk to ASM Diskgroup in 11gR2

Reader Mode We can use the following steps to migrate OCR and Vote Disk from RAW to ASM Disk. Step 1:- Check the current OCR…

Anup October 5, 2023

0 Comments

Upgrade CRS and Database 10.2.0.1 to 10.2.0.5

Reader ModeFirst Task to Upgrade CRS Database Name: PROD Instances: PROD1 Node name: racnode1 Instances: PROD2 Node name: racnode2 Oracle Database Home and ASM Home:…

Anup October 6, 2022

0 Comments

Generate Create Tablespace Script

Reader Modeset serveroutput on size 1000000 DECLARE CURSOR get_ts IS SELECT * FROM dba_tablespaces WHERE tablespace_name != ‘SYSTEM’; CURSOR get_df (p_ts VARCHAR2) IS…

Anup October 5, 2023

0 Comments

Related Articles

Responses