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

-----Original Message-----

From: Larry Elkins [mailto:elkinsl_at_flash.net] Sent: Wednesday, January 26, 2005 4:26 PM To: MGogala_at_allegientsystems.com; oracle-l_at_freelists.org Subject: RE: LOB's -- How Many Out of Line?

And in 9i, like in my example before, I can get by with LENGTH and not have to use DBMS_LOG.GETLENGTH like I would in 8i. And use 3964 instead of 4K (at least according to various Metalink documents). But I guess my question is is this the only way? Is that what I'm supposed to assume from your reply? Because I'm starting to think, after a couple of days of googling and metalinking, that this really is the only way to know. So are you also saying this is the only way?

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 26 2005 - 17:02:44 CST