Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Finding the size of a BLOB field
But that only works if you first extract the blob.. right? I'm looking for
something to just query the size (as in vsize), without having to excract to
get an object and then query that - for a large db with large blobs, that
would REALLY slow things down.. no?
-Thanks
Ati
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3c3ecce2$0$231$ed9e5944_at_reading.news.pipex.net...
> dbms_lob.get_length
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Ati Rosselet" <ati.rosselet_at_clarmont.hu> wrote in message
> news:a1mi9v$atu$1_at_proxy.interware.hu...
> > Is there any way (I cant find one so far) of determining the actual size
> (in
> > bytes) of a BLOB field? vsize is great for all other field types.. but
> > doesnt want to work on blob. any ideas?
> > Thnx
> > -Ati
> >
> >
>
>
Received on Fri Jan 11 2002 - 05:54:45 CST