Re: 'Alter index rename subpartition' on table with not commited data (from other session)

Wojciech Klapyta wrote:
> Hi everybody!
>
> ALTER INDEX foo RENAME SUBPARTITION bar1 TO bar2; when foo is a bitmap
> index results in an ORA-0054 error "Resource busy with NOWAIT specified"
> when the table this index belongs to, contains uncommitted data (created
> in another session) - even if the data are not in bar1 subpartition of
> the table.
>
> Does anybody konw if:
>
> 1) the whole foo index is read/rebuild during ALTER INDEX foo RENAME
> SUBPARTITION bar1 TO bar2; ?
> 2) is there a workaround for ORA - 0054 exception in this case?
>
> Thanks in advance for your help,

1. Likely not. But that is not your problem. Your problem is you have a parse lock on the affected object.
2. Yes. Kick out the other users.

--
Sybrand Bakker
Senior Oracle DBA