Re: HELP need !! ------- ISAM error version 5

maverick wrote: > > hi all, > > I need your expertized advice now, thanks in advance. > > My db version is 5 HP-UX 9.05,and usually quite stable in > past 1.5 years. I have problem on unable to delete from > one of my table , error 105, "error isam file format" > corrupted?? > > It may impossible to re-create the table again, how can I > rescue from this. I have used tbcheck -cirec, but it seems only > checking the db. I need the way to solve it. > > robert Robert, First try to unload the table (unload to "xxx.unl" select * from xxx); this usually works even if the table is mildly corrupted. Next, try all tbchecks that make sense, and see if it say you something. If not, assume that indices are culprits; drop them and rebuild them. Finally, it nothing happens, drop the table, recreate it, and load from unload file. If the very first step (unload) fails, then you are really in trouble... Good luck! Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+