RE: Finding LOB columsn

From: <oracle-l-bounce_at_freelists.org>
Date: Fri, 1 Jul 2005 15:13:51 -0400
Message-ID: <D63E582D09D77648A106C164FC7C483201C26270@mail1-corp.corp.paetec.com>

OR

select * from dba_lobs.

This won't tell you what type of LOB but it will tell you the actual name of the LOB segment and index name as well.

Rich

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Friday, July 01, 2005 3:10 PM
To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org Subject: RE: Finding LOB columsn

How about:

select * from DBA_tab_columns
where data_type like '%LOB%'

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Friday, July 01, 2005 3:07 PM
To: oracle-l_at_freelists.org
Subject: Finding LOB columsn

Is there an easy way to find all of the tables in the database that have LOB
columns regardless of who owns them?

---

Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 01 2005 - 15:19:19 CDT