Monday 23 July 2012

Indexes and the Recyclebin

I found out recently that if a table is dropped (without PURGE) and the table has indexes, then, if the table is "undropped", using:

FLASHBACK TABLE my_table TO BEFORE DROP;

the table's indexes are also restored but with their recyclebin names. You can rename such indexes later to their original names.

This is still the behaviour in 11.2.0.3.

So, keep a record of index names before performing any table drops, if you want to avoid problems finding out their original names.

No comments:

Post a Comment