I have been working on a 10 TB project. In mid course, it went down to 3 TB just by using a java compress function as an interface to store in/serve out the CLOBS, whose algorithm is quite similar to gzip algorithm to compress the CLOBS. It made a huge save in SAN costing. Though I am quite ignorant of the 25k java functions standard now in 10g, I wonder if there is not a java builtin version of gzip into latest revisions of 10g. Someone can confirm? B. Polarski -- //www.freelists.org/webpage/oracle-l