RE: Extents

Steve Yes, much better. ALTER TABLE tablename NEXT SIZE whatever; ALTER FRAGMENT ON TABLE tabname INIT IN your_dbspacename; This will rebuild the table. You cannot alter the primary EXTENT SIZE without dropping the table. This allows you to create a table with 2 extents - depending upon the amount and size of free space in your_dbspacename. You need sufficient space for 2 copies of the table if reorganising in the same dbspace. You can move tables to another dbspace with the second statement. Murray Wood -----Original Message----- From: Steve Schroeder [SMTP:zamdrist@pconline.com] Sent: Thursday, November 11, 1999 5:28 PM To: informix-list@iiug.org Subject: Extents IDS7.3 I need to expand the extents for most or all of our tables in our db. What would be the best way to go about this? The only obvious idea I have for now is to do a dbexport, edit the output to reflect larger extents, drop all tables and then do a dbimport? We are talking about over 100 tables and this would be a very tedious proccess. Any better ideas? Thanks! Steve