Re: please help! eror 252

Jorge Torralba wrote: > > Oscar Goldes wrote: > > > > Can you explain this? > > (Online 7.2) > > > > dbschema stops with error code -252, ISAM code -113: > > > > It happens very often, sometimes it finishes without errors > > The explanation of the codes is > > > > -252 Cannot get system information for table. > > We ran into this situation all the time on most of our very active tables (very heavy inserts and updates). We could never get a full schema of the entire database because of this. We finally created a script that would do a dbschema of each individual table. The script would check for that particular error above and would loop until it got the schema. We tried about 10 times to get the schema and then exited out. We were able to get the schema most of time with this method. We ran this script during off-hours so that there would be a better chance of getting the schemas. We would then have to get the other parts of the schema (stored procedures, permissions, triggers, etc) separately. Stefanie Vario ZenaComp Incorporated svario@zenacomp.com