Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Finding LOB columsn

Re: Finding LOB columsn

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Fri, 01 Jul 2005 15:31:50 -0400
Message-ID: <42C59A26.1070907@allegientsystems.com>


J. Dex wrote:

> 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

select owner,table_column_name from dba_tab_columns where data_type not like '%LOB'

-- 
Mladen Gogala
Oracle DBA
Ext. 121


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US