Re: need help with script
Date: Wed, 23 Sep 2009 18:54:32 +0530
select DISTINCT table_name ,OWNER from dba_tab_columns where OWNER NOT IN ('SYS','SYSTEM')
AND DATA_TYPE <>'LONG'
On Wed, Sep 23, 2009 at 6:41 PM, Helen Mitchell <HelenJMitchell_at_comcast.net>wrote:
> 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.