Re: How to analyse existing blobs

Just select length(blob), works fine on text and images AFAIR, it should be OK on clob but I've never tried. The alter table is OK but it will be slow. Andrew Hamm wrote: > > Hi folks > > I've never used blobs, but now I'm helping to resize and reorganize an > engine. > > How do I get a dump of the sizes of existing blobs used in their live data? > I want to work out a decent pageunit to use to optimise space and time on > the bulk of their blobs > > thanks in advance. > > oh - another Q. Once we've created a blob space, what's the trick (if any) > for relocating their existing in-table blobs out to a blobspace? Just a > simple application of the ALTER TABLE command in the expected manner? -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #