Hi all,

After some experiments i have a reasonable understanding of external tables now.

Please correct me if i am wrong.
Whatever data is in the table goes to the external file, and vice-versa. So at the time of backup, the table that is linked to the external file will be deleted, and then backup will be performed.

Whereas at the time of restore, the table will be created with the data in the external file.

is it correct.?

thanking you

Abhishek Sharma

--- In firebird-support@yahoogroups.com, "abhishek_dsc" <abybaby123@...> wrote:
>
> I dont have much knowledge about external tables, let me study them and will get back if i have any doubts.
>
> But, i would like to say that the raw data should be created and populated by us...i hope this should be possible in external tables.?
>
> thanking you
> Abhishek Sharma
>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@> wrote:
> >
> > At 06:00 PM 23/12/2009, you wrote:
> >
> > >Hi,
> > >
> > >We have an application which takes some raw data as input, processes it and stores the output in different tables.
> > >Now i dont want my raw data to be the part of the backup, as over a period of time the raw data will increase.
> > >
> > >Also, i dont want to delete the raw data from my original database, unless the user explicitly asks to delete the data.
> > >
> > >I thought of keeping the data in a seperate db initially, but later thought certain queries may take long time to execute.
> >
> > Well - either
> > / you want the raw data in the database (because you have to return to it for some reason) and therefore it should be backed up
> > or
> > /you are not interested in the raw data once it has been extracted into tables
> >
> > Are you using external tables for the raw input?
> >
> > ./heLen
> >
>