Posted in 1998
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
>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
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.