Re: Diagnostic & Violations tables

stiglich@promarkone.com wrote: > > Hello, > > Is there a way to give extent sizes for diagnostics & violations > tables that are created by High Performance Loader? It seems to > default to 8 pages. This is not good when you have a very large > load because you get extents scattered all over the place. Pete, probably not, because that kind of control is not part of the "start violations table" command. However, after running the START command, you should be able to ALTER TABLE blah_vio NEXT SIZE 100000 ALTER TABLE blah_dia NEXT SIZE 100000 so that the major part of the violations/diagnostic tables are in a huge extent. This is almost as good, I think. > TIA I don't know what language TIA is, but I hope it's followed by MARIA and I'd drink it on the rocks. ;-) -- -- Jake (In pursuit of undomesticated aquatic avians and cofee flavored beverages) +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+