Re: need help with script
From: Joey D'Antoni <jdanton1_at_yahoo.com>
Date: Wed, 23 Sep 2009 06:27:05 -0700 (PDT)
Message-ID: <599180.58931.qm_at_web59001.mail.re1.yahoo.com>
This should work--you probably need to edit the schema list to reflect options installed in your database.
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
Date: Wed, 23 Sep 2009 06:27:05 -0700 (PDT)
Message-ID: <599180.58931.qm_at_web59001.mail.re1.yahoo.com>
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 <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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 23 2009 - 08:27:05 CDT