Thanks to all for advise on my problems with reloading; don't know yet the best course of action, though will try same procedure via rbwin per one suggestion. BTW, Tony, your set of commands match mine line by line - also, still have same "out of dynamic space" problems. Have to re-create indices on about 7 columns after every reload.
Brad William Cook wrote: > 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 > >
begin:vcard n:Davidson;Brad tel;fax:909-736-4699 tel;work:909-736-4690 x-mozilla-html:FALSE url:www.aero-craft.com org:Aero-Craft Hydraulics, Inc.;Customer Support adr:;;392 North Smith Avenue;Corona;CA;92880-6971;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Manager fn:Brad Davidson end:vcard
