Subject Re: [firebird-support] Store a table in a another datafile
Author Bogusław Brandys
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 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]


From helebor@... Mon Aug 10 13:58:19 2009
Return-Path: <helebor@...>
X-Sender: helebor@...
X-Apparently-To: firebird-support@yahoogroups.com
X-Received: (qmail 61611 invoked from network); 10 Aug 2009 20:58:09 -0000
X-Received: from unknown (98.137.34.46)
by m6.grp.re1.yahoo.com with QMQP; 10 Aug 2009 20:58:09 -0000
X-Received: