Cause: An attempt was made to create, alter or drop an index on temporary table which is already in use.Action: All the sessions using the session-specific temporary table have to truncate table and all the transactions using transaction specific temporary table have to end their transactions.
等该session释放了表再删除吧。
或者停掉数据库重启动之后删除?(太小题大做了吧?)