Re: table extents in what chunks?

The first 12 bits (3 nibbles or hex digits) represent the chunk number. If you reorg extents are allocated from the lowest numbered chunk in the dbspace that has a large enough freespace to accomodate the FIRST EXTENT and NEXT EXTENT sizes. Prior to reorging with ALTER FRAGMENT...INIT IN... you should reset the NEXT SIZE with ALTER TABLE tabname NEXT SIZE .... Art S. Kagel c-eriks@algonet.se wrote: > > In article <3A11B74B.3E2AE930@bloomberg.net>, > kagel@bloomberg.net wrote: > > c-eriks@algonet.se wrote: > > SELECT * > > FROM sysextents > > WHERE dbsname = "mydatabase" and tabname = "mytable" > > ORDER BY start;> > Art S. Kagel > > > > How do I find out what chunk the start addresses refers to? What chunk > will be used for the rebuild (ALTER FRAGMENT .... init mydbspace) of > the table if the dbspace consists of many chunks? > > Sent via Deja.com http://www.deja.com/ > Before you buy.