Oracle rollback not only rolls back the data in the table but also the indexes in the table.

There is a scenario where the user information table uses deletel; insert into select; To update user data. This causes keyword exceptions and data loss.

There is no way to re-import data from another database; truncate table userinfo; insert into userinfo select * from o_userinfo @ backup;

During execution, I forgot to erase the index of the old table. The size of the 5.7 million data in the original table is GB, which includes 6 indexes and 1 keyword. The size is unknown. It has been inserted for a long time, and it takes almost two hours. No way to KILL-9 XXXXX to drop it,

After kill, oracle rolls it back and Its indexes. I have never finished rolling back from. All in db sequenct read file;

 

Drop indexe. xxxxx; the index rollback is stopped immediately!