Freeing Extents

Posted in 2006

Tam O'Shanter — Fri, 10 Nov 2006 14:41:55 GMT — source: Usenet: comp.databases.informix

Hello, Is there any way to free extents allready claimed by a table after removing data from said table? Running out of disk space for a table and I wish to delete an ammount of data. IFX 10.0UC5 Thanks for the advice, Tam.

↪ replying to Tam O'Shanter

Obnoxio The Clown — Fri, 10 Nov 2006 14:53:17 -0000 (GMT) — source: Usenet: comp.databases.informix

Tam O'Shanter said: > Hello, > > Is there any way to free extents allready claimed by a table after > removing > data from said table? > > Running out of disk space for a table and I wish to delete an ammount of > data. I don't know if there's anything new in 10 to take of this, but I'd do an ALTER INDEX TO CLUSTER after the delete. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.