Re: need help with script
Date: Wed, 23 Sep 2009 06:27:05 -0700 (PDT)
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'
From: Helen Mitchell <HelenJMitchell_at_Comcast.net> To: oracle-l <oracle-l_at_freelists.org>; Helen Mitchell <helen.j.mitchell_at_ulalaunch.com> 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