Shulou(Shulou.com)05/31 Report--

This article focuses on "how to solve the problem of oracle online index creation interruption", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "how to solve the problem of oracle online index creation interruption"!

The session is interrupted during the online index creation operation, and the index is in the middle state. When you try to delete, rebuild, or rename the index, the following error occurs:

Ora-08104: the index object 216832 is being established or rebuilt by a connection

Generally, you can wait for the SMON background process to clean up automatically. You can also use DBMS_REPAIR.ONLINE_INDEX_CLEAN for manual cleanup.

Syntax:

DBMS_REPAIR.ONLINE_INDEX_CLEAN (

Object_id IN BINARY_INTEGER DEFAULT ALL_INDEX_ID

Wait_for_lock IN BINARY_INTEGER DEFAULT LOCK_WAIT)

RETURN BOOLEAN

If the cleanup is successful, return TRUE;. If there are objects that have not been cleaned successfully, return FALSE.

Wait_for_lock:

This parameter specifies whether to try getting DML locks on underlying table [[sub] partition] object. The default retries up to an internal retry limit, after which the lock get will give up. If LOCK_NOWAIT is specified, then the lock get does not retry.

Simple call:

SQL > conn / as sysdba

SQL > DECLARE

IsClean BOOLEAN

BEGIN

IsClean: = DBMS_REPAIR.ONLINE_INDEX_CLEAN ()

END

/

The actual problems encountered were cleaned up automatically after waiting for more than 40 minutes. Checked the trace file of the SMON process and did not record the relevant information.

At this point, I believe you have a deeper understanding of "how to solve the problem of interruption in oracle online indexing". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.