Subject | How to re-activate index which de-activate from restore option ? |
---|---|
Author | kamen_lai |
Post date | 2006-03-30T14:37:50Z |
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
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