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

You don't seem to understand my response. During the alter index operation you need to block the table for further access.
The fact someone else is using it (and has a parse lock on the index definition) precludes you from doing so. The whole index is NOT recalculated, but you can't access it, because the table is in use!!!

For a workaround you need to verify (in the SQL reference) whether you can do this ONLINE and add the ONLINE keyword to the statement. For ONLINE rebuilds you'll need Enterprise Edition.

---
Sybrand Bakker,
Senior Oracle DBA