Re: need help with script

From: Joey D'Antoni <>
Date: Wed, 23 Sep 2009 06:27:05 -0700 (PDT)
Message-ID: <>

This should work--you probably need to edit the schema list to reflect options installed in your database.

select distinct owner,table_name
from dba_Tab_cols where owner not in
('SYSTEM','XDB','SYS','TSMSYS','PERFSTAT','OUTLN','DBSNMP') and data_type <> 'LONG'

Joseph D'Antoni
Synthes USA

From: Helen Mitchell <> To: oracle-l <>; Helen Mitchell <> Sent: Wednesday, September 23, 2009 9:11:18 AM Subject: need help with script    

I need a script that will select the owner and table names for the user-defined schemas that do not have any columns defined with a datatype = LONG. The script need to skip the table if any column is defined as a datatype = LONG.       

Received on Wed Sep 23 2009 - 08:27:05 CDT

Original text of this message