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: from unknown (HELO outbound.icp-qv1-irony-out2.iinet.net.au) (203.59.1.107)
by mta3.grp.sp2.yahoo.com with SMTP; 10 Aug 2009 20:58:09 -0000
Message-Id: <8148ph$gbnlaq@...-qv1-irony-out2.iinet.net.au>
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: ApoEAEgmgEp8qtdH/2dsb2JhbADVcwU
X-IronPort-AV: E=Sophos;i="4.43,355,1246809600";
d="scan'208";a="549180762"
X-Received: from unknown (HELO dev1.mail.iinet.net.au) ([124.170.215.71])
by outbound.icp-qv1-irony-out2.iinet.net.au with ESMTP; 11 Aug 2009 04:57:44 +0800
X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9
Date: Tue, 11 Aug 2009 06:57:46 +1000
To: firebird-support@yahoogroups.com
In-Reply-To: <b1fec7230908101256v681065belda89fb57d46b6765@...
m>
References: <b1fec7230908100614o6f907a3cg33457a4640bdded8@...>
<4A8021D0.60504@...>
<b1fec7230908101256v681065belda89fb57d46b6765@...>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Originating-IP: 203.59.1.107
X-eGroups-Msg-Info: 1:12:0:0:0
From: Helen Borrie <helebor@...>
Subject: Re: [firebird-support] Store a table in a another datafile
X-Yahoo-Group-Post: member; u=255078333; y=M1bR5fnhoOl1cVQQ4P2fE3NMKs6lzRZJnLfVFjcv28qlJw
X-Yahoo-Profile: helebor

At 05:56 AM 11/08/2009, you wrote:

>Is it not possible to define a table to be stored in a data file

No.

> as well as in another DB engines?

Some other DB engines are file-based. Firebird is not.

You should start again and try to describe the symptoms of the apparent corruptions. That way, people may be able to help you to find out what is causing the corruption and how to prevent it recurring.

./heLen


From helebor@... Mon Aug 10 14:15:21 2009
Return-Path: <helebor@...>
X-Sender: helebor@...
X-Apparently-To: firebird-support@yahoogroups.com
X-Received: (qmail 65068 invoked from network); 10 Aug 2009 21:15:12 -0000
X-Received: from unknown (98.137.34.44)
by m7.grp.re1.yahoo.com with QMQP; 10 Aug 2009 21:15:12 -0000
X-Received: from unknown (HELO outbound.icp-qv1-irony-out3.iinet.net.au) (203.59.1.148)
by mta1.grp.sp2.yahoo.com with SMTP; 10 Aug 2009 21:15:11 -0000
Message-Id: <7fcdv6$eiri6c@...-qv1-irony-out3.iinet.net.au>
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: ApoEAO8qgEp8qtdH/2dsb2JhbADULQGBNwWBTA
X-IronPort-AV: E=Sophos;i="4.43,355,1246809600";
d="scan'208";a="489539788"
X-Received: from unknown (HELO dev1.mail.iinet.net.au) ([124.170.215.71])
by outbound.icp-qv1-irony-out3.iinet.net.au with ESMTP; 11 Aug 2009 05:14:35 +0800
X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9
Date: Tue, 11 Aug 2009 07:14:36 +1000
To: firebird-support@yahoogroups.com
In-Reply-To: <000901ca19b8$b488edf0$1d9ac9d0$@gr>
References: <000901ca19b8$b488edf0$1d9ac9d0$@gr>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Originating-IP: 203.59.1.148
X-eGroups-Msg-Info: 1:12:0:0:0
From: Helen Borrie <helebor@...>
Subject: Re: [firebird-support] ERROR!NONE OF THE DYNAMIC LIBRARIES CAN
BE FOUND: FBCLIENT20.DLL, FBCLIENT.DLL REFdn6005800544
X-Yahoo-Group-Post: member; u=255078333;