Re: Corrupt indexes on a system catalog

dbexport -ss gives the server specific information including extent sizeslock levels and dbspace assignments. Taking the logging off the database until it is loaded avoids any long transaction issues. I don't disagree with your other comments though Felix, I simply prefer to use dbexport because it is a known quality to me, and I do not have a background of using unloads, named pipes etc. I can imagine that others like yourself, who are comfortable at this level would prefer not to use dbexport. cheers Peter Tashkoff <tashkop@iname.com> Zespri International Limited Std Disclaimers Apply All rights reserved. No party may use this document to vilify another. Zespri New Zealand Kiwifruit, The World's Finest >>> Felix Koshy Mathews <fmathews@systems.DHL.COM> 8/01/98 11:34:32 >>> Stuff snipped Normally any well designed/tuned dbschema will have first & next extend = sizes and lock level differing from the default sizes of 16-pages (were 8 = before) and page level locking ( a major screw-up on OLTP ). When you dbimport your database will be nailed to these defaults. Now = after the dbimport if you don't happen to have any document saying what = where those extend sizes before, you will end up re-doing the calculations.= Other problems are like long transaction, etc. for which you can have = workarounds. stuff snipped