Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
README | 2019-06-13 | 614 Bytes | |
reorg | 2019-06-13 | 11.8 kB | |
Totals: 2 Items | 12.4 kB | 0 |
README Allows a DBA to change the dbspace, the initial and next extent sizes for a table. What it does is unload the data, dump the schema into a temporary file, edit it using the user supplied parameters for table dbspace, initial and next extent sizes and the index dbspace, drop the table and recreate it using the new (edited) schema and the data. It also allows the DBA to put the indexes into a separate dbspace for performance reasons. Can be run on a single table or on all tables in the database. Can also be run with the existing (default) parameters to eliminate fragmentation in tables with high i/o.