Hi Jonathan,
You know i support the addition of truncate table.
Also, one i forgot to mention at the time is shrink datafile. If i create
a datafile of 200 MB, and autoextend it to let's say 2 GB..... ... and then
for whatever reason i truncate the table(s) in this datafile/tablespace such
that it no longer takes anywhere near the 2 GB.... i can attempt to release
space by shrinking the datafile back to it's originally defined size of 200
MB. (had i started out by defining the datafile as 2Gb, ... i can only
shrink to 2GB, but if i define as 200 MB, and autogrow to 2 GB, i have the
ability to shrink back to 200MB if needed... and space inside the datafile
is not used....and wa-la, my database has just painlessly released 1.8 GB of
space.... cool....)....
thanks,
Norma Jean
"Jonathan Leffler" <jleffler@earthlink.net> wrote in message .......
> Jonathan Leffler #include <disclaimer.h>
> Email: jleffler@earthlink.net, jleffler@us.ibm.com
> Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/