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

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, Received on Mon Jun 06 2005 - 06:35:15 CDT