Table Reorgs

Posted in 2000

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion

Arshad, Shehla — Thu, 13 Jan 2000 17:22:26 -0500 — source: Informix-list mailing list archive (1991-1998)

Can anybody suggest a good strategy for putting tables back into lesser extents other than unload/load. We are currently using alter fragment on table init in dbspace, but it doesnt always give desired results. Thx Shehla

↪ replying to Arshad, Shehla

Neil Truby — Sat, 15 Jan 2000 23:48:46 -0000 — source: Informix-list mailing list archive (1991-1998)

>Can anybody suggest a good strategy for putting tables back into lesser >extents other than unload/load. We are currently using alter fragment on >table init in dbspace, but it doesnt always give desired results. I'd say ALTER TABLE is the safest and most flexible, although it can be a problem with detached indexes. What problems are you getting?

Glossary

dbspace