Re: Defraging

From: "howard.jones" <howard.jones@iclway.co.uk> > >We are in the process of defragging tables in our database..... >The process we follow is as follows, >Edit dbschema with new extents, >unload the table, drop it >run dbschema sql >reload table. >Once this has been done we are finding the table has the same extents as >before. >i.e. pointless exercise... >Why is this happening, does anyone have other ways of doing defrags. Beats me. How about ALTER FRAGMENT ... INIT IN.... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com