RE: LOB's -- How Many Out of Line?
- From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
- To: "'elkinsl@xxxxxxxxx'" <elkinsl@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 26 Jan 2005 14:28:19 -0500
--
Mladen Gogala
Ext. 121
-----Original Message-----
From: Larry Elkins [mailto:elkinsl@xxxxxxxxx]
Sent: Wednesday, January 26, 2005 1:25 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: LOB's -- How Many Out of Line?
Listers,
Assuming a CLOB, for example, was defined with ENABLE STORAGE IN ROW. Is
there an easy and *fast* way to determine how many of them are out of line?
[Mladen Gogala]
SELECT count(*) from TABLE_CONTAINING_LOB_COLUMNS WHERE
DBMS_LOB.getlength(LOB_COLUMN)>4000;
--
//www.freelists.org/webpage/oracle-l
Other related posts:
