Subject Re: [firebird-support] Store a table in a another datafile
Author Alexandre Benson Smith
Ramiro Barreca wrote:
> We have a hugh database of more than 10 GB

Not so huge ;)

> that usually became corrupted,
> but we cannot repair it with a simple gfix command.
> In this database there is a table with over 50 million records that grows up
> at 130000 records/month. This is the one we suspect is the problem of
> corruptions.
>

You should have no corruptions, no matter if a tbale grows by 130000 or
by 1 record/month.

Provide more information and perhaps the FB gurus could give you some hints.

> We think it would be better to have this table on another datafile that we
> can repair on a better way.
> We have seen that we can create a second datafile, but how to transfer only
> this database to the new one?
>

It's not possible.

> Thanks in advance.
>
> Ramiro Barreca
>


see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br