Cleaning up interrupted online index builds

To clean up failed online index builds, use the Amazon RDS procedure rdsadmin.rdsadmin_dbms_repair.online_index_clean.

The online_index_clean procedure has the following parameters.

Parameter name	Data type	Default	Required	Description
object_id	binary_integer	ALL_INDEX_ID	No	The object ID of the index. Typically, you can use the object ID from the ORA-08104 error text.
wait_for_lock	binary_integer	rdsadmin.rdsadmin_dbms_repair.lock_wait	No	Specify rdsadmin.rdsadmin_dbms_repair.lock_wait, the default, to try to get a lock on the underlying object and retry until an internal limit is reached if the lock fails. Specify rdsadmin.rdsadmin_dbms_repair.lock_nowait to try to get a lock on the underlying object but not retry if the lock fails.

The following example cleans up a failed online index build:

declare
  is_clean boolean;
begin
  is_clean := rdsadmin.rdsadmin_dbms_repair.online_index_clean(
    object_id     => 1234567890, 
    wait_for_lock => rdsadmin.rdsadmin_dbms_repair.lock_nowait
  );
end;
/

For more information, see ONLINE_INDEX_CLEAN function in the Oracle documentation.