kamen_lai wrote:

> 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.

Why do you need to restore the database?

> So, how can i reactivate all index ?

Run this query:

select 'ALTER INDEX '||rdb$index_name ||'ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0;


Copy/paste the results you get and run that.

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org