Re: Deadlock in stored procedure

>
>sorry for the missing information, I forgot that these things are
>rather important. I'm running Oracle 9.2.0.4 on a Windows XP SP1
>desktop. The message stack that I get looks like:
>
>BEGIN LOAD_FILE_TO_MY_DOCS('InstallSolaris.pdf'); END;
>
>*
>ERROR at line 1:
>ORA-04020: deadlock detected while trying to lock object TEST.MY_DOCS
>ORA-06512: at "TEST.LOAD_FILE_TO_MY_DOCS", line 15
>ORA-06512: at line 1
>
>Looks like the error occurs while the 'alter index' statement is being
>processed.
>

Hi Bert,

Ok, it's a text domain index on column doc.

AFAIK, Oracle does not recommend rebuilding text domain indexes with the SYNC option. I suggest you separate the syncronization from the rebuild by means of CTX_DDL.SYNC_INDEX.

Hope this helps.

• Kenneth Koenraadt