Cleaning up interrupted online index builds - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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.