Re: Export/Import Database - Help??

>>>>> Richard Spitz <spitz@GANS2X.ana.med.uni-muenchen.de> writes: > How can Online fit all tables into one extent? AFAIK, dbimport > uses the default extent size of 16k, so large tables will get > split into many little pieces, and performance will degrade serious- > ly if the number of extents exceeds 8 for a table. If you load all rows of a table at once, OnLine will create adjacent extents (if space permits). In "Guide to SQL - Tutorial" at the bottom of page 10-11: "When a new extent is created adjacent to the previous extent, the two are treaded as a single extent." So in case of initial loading the first extent size you specify is effectively treated as a minimum extent size. In our experience it works as documented. -- Oliver Okrongli infix Software-Systeme GmbH Phone +49 531 238090 Rebenring 33 Fax +49 531 2380935 oliver@infix.de 38106 Braunschweig F.R. Germany