|
[oracle-l]
||
[Date Prev]
[07-2005 Date Index]
[Date Next]
||
[Thread Prev]
[07-2005 Thread Index]
[Thread Next]
Re: Finding LOB columsn
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: cemail_219@xxxxxxxxxxx
- Date: Fri, 01 Jul 2005 15:31:50 -0400
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
|
