Subject | Re: [firebird-support] Store a table in a another datafile |
---|---|
Author | Ramiro Barreca |
Post date | 2009-08-10T19:56:33Z |
Is it not possible to define a table to be stored in a data file as well as
in another DB engines?
Ramiro
2009/8/10 Alexandre Benson Smith <iblist@...>
Ramiro Barreca
rbarreca@...
[Non-text portions of this message have been removed]
in another DB engines?
Ramiro
2009/8/10 Alexandre Benson Smith <iblist@...>
>--
>
> 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
>
>
>
Ramiro Barreca
rbarreca@...
[Non-text portions of this message have been removed]