Subject Re: [IB-Architect] Database files > 2GB.
Author Ann Harrison
At 09:57 AM 4/27/00 -0300, Fabricio Araujo wrote:
>On Wed, 26 Apr 2000 14:48:56 -0700, Bill Karwin wrote:
> >It would be challenging to do so in the general case, because if there are
> >many files with long pathnames, the list can easily fill up the header page.
> >InterBase allocates more header pages as necessary to store all the
> >filenames. The extra header pages are not necessarily contiguous.

In fact, they're necessarily not contiguous with the initial header.

> >
> >The system table RDB$FILES stores the paths of secondary files and shadow
> >files, but this is read-only; changing these values _doesn't_ change where
> >InterBase looks for the secondary files.
>I think the path to solve this trouble is making RDB$FILES the target to
>look for secondary files.
>So, a simple update can do the work. And there no need to change
>the ODS, this can remain as it is, since it's only a behavior change on
>the server.
>I think this will be simpler than going hunting high and low on the header
>pages .

The problem with that is that the RDB$FILES table itself may be in
a secondary file.