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

--

Mladen Gogala
Ext. 121
-----Original Message-----

From: Larry Elkins [mailto:elkinsl_at_flash.net] Sent: Wednesday, January 26, 2005 1:25 PM To: oracle-l_at_freelists.org
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;

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 26 2005 - 14:30:49 CST