I may just be "good lucky", I haven't noticed any problem since Razzak et
alia corrected my trigger problem.
I always unload the structure and the data separately.
I break the structure file into two pieces. The first piece creates the
schema and the second piece creates the indexes.
I then do my reload by:
1. running the "schema create" piece
2. loading the data
3. running the "create indexes" piece
Bill Cook
Kent WA USA
----- Original Message -----
From: "Dennis McGrath" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 4:22 PM
Subject: RE: Losing Indices
> I never reload with RBDOS anymore. Can't rely on it. Do all reloads with
> RBWIN.
>
> -- Dennis McGrath
> mailto:[EMAIL PROTECTED]
>
> -- Productivity Tools for R:Base Programmers
> http://www.enteract.com/~mcgrath/dennis
>
> -- Full time consultant with:
> SQL Resources Group
> Steve Hartmann
> Oak Park, IL
> mailto:[EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Brad Davidson
> Sent: Monday, December 03, 2001 2:35 PM
> To: Rbase List Questions
> Subject: Losing Indices
>
>
> Have been doing same daily maintenance chore for past 10 years, unload
> and 'reload' of database. When reloading, get following error messages:
> "Out of dynamic space; insufficient space to process alter command (
> 235)"
>
> This occurs only at end of process, wherein indexes are re-created. I
> lose about 6 - 8 indices.
>
> Win98 OS, Rbdos 6.5++, have re-booted before running process to free all
> available memory, have 256mb of RAM on server, entire db size: 195mb, #2
> is 161mb.
>
> Any ideas?
>
> Thanks in advance!
>
> Brad Davidson
>
