RE: LOB's -- How Many Out of Line?

  • From: "Larry Elkins" <elkinsl@xxxxxxxxx>
  • To: <MGogala@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Jan 2005 16:29:15 -0600

Ok, I see why you replied with the GETLENGTH response (I left it out for
brevity in the original). But thanks for taking the time to mention it! I
guess we will stick with the LENGTH approach on 9i and the
DBMS_LOB.GETLENGTH approach on 8i. I haven't done much with LOB's and am
learning a gazillion things about them each day (and a lot of things I'm not
crazy about).


Larry G. Elkins

> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Gogala, Mladen
> Sent: Wednesday, January 26, 2005 4:00 PM
> To: 'Larry Elkins'; Gogala, Mladen; oracle-l@xxxxxxxxxxxxx
> Subject: RE: LOB's -- How Many Out of Line?
> You specifically mentioned both 8i and 9i, which lead me to the DBMS_LOB
> instead of length. That is the only way that I am aware of to
> find out which
> LOBs "oozed" to the LOB tablespace. I have no magic bullet. As a matter of
> fact, I don't have any ammo whatsoever. I use sticks and stones to break
> bones.
> I would never say that it is the only way, I say that this is the
> only way I
> know of. There may be others with more thorough knowledge of Oracle and
> firearms on this list.
> --
> Mladen Gogala
> Ext. 121


Other related posts: