That error means that somebody is using that index. Query dba_locks to see which session is using that object and then kill that users session to free the locks (after the transaction rolls back).