Hi all,
I have a damaged DB which is very important (in the client's words!)
It is possible to GBAK it with FB1.0's GBAK.
It is NOT possible to restore it with gbak: it outputs an error
on index RDB$FOREIGN140
...
'action cancelled wiby trigger(3) to preserve data integrity
cannot deactivate primary index'...
...
I thought to backup the DB and restore it without index activation,
so I performed
gbak ... -inactive
and the restore went OK.
BUT, all indexes are inactive.
There are some 372 indexes in this db, counting primary and foreign
keys and extra indexes.
the question is;
how can I activate all these indexes 'programmatically', i.e. without
explicitly activating each one of them via IBConsole?!

TIA,
Luca.