Re: first extent and next extent

>Hi, >I want to know that is there a system table include >first and next extent size information ? >and how can i keep the origin extent size during >dbexport and dbimport easily ? >and how can i change the first extent size after >dbimport (for i know change next extent size by alter >table statement)? The sysextents table in the sysmaster database should give you what you are asking for. Just select everything and order by tabname. The original extent size info is stored in a file called <database name>.sql in the export directory along with all the unload files. This is used to create the tables when you import the database back in and keep the extent sizes you currently have. You can modify this file to create larger first extents (and next extents if nec.) and then dbimport the database. Craig Lanford Mailto:craig.lanford@alltel.com