Subject How to re-activate index which de-activate from restore option ?
Author kamen_lai
While i need to datapump from 1 gdb to another gdb, i use ibdatapump
from clevercomponents. The original database have about 1 million
records. Due to i want to speedup the pumping process, i restore the
destination database with deactivate index option on.

The whole process take about 20 min compare with 2.5 hours using index
active. But after pumping completed, when i do backup & restore with
new database , i found that all index still in inactive status even i
did not use deactivate index option. It's seen that backup also keep
track index status and restore back in database.

So, how can i reactivate all index ?

thanks in advance

Kamen Lai