Re: need help with script
From: Daniel Fink <daniel.fink_at_optimaldba.com>
Date: Wed, 23 Sep 2009 07:26:29 -0600
Message-ID: <4ABA2205.9030006_at_optimaldba.com>
/
Date: Wed, 23 Sep 2009 07:26:29 -0600
Message-ID: <4ABA2205.9030006_at_optimaldba.com>
SELECT owner , table_name FROM dba_tables WHERE (owner,table_name) NOT IN (SELECT owner, table_name FROM dba_tab_columns WHERE data_type LIKE 'LONG%') -- excludes LONG and LONG RAW AND owner NOT IN ('SYS', 'SYSTEM') -- add schema names to excludeORDER BY owner, table_name
/
Regards,
Daniel Fink
-- Daniel Fink OptimalDBA http://www.optimaldba.com Oracle Blog http://optimaldba.blogspot.com Lost Data? http://www.ora600.be/ Helen Mitchell wrote:Received on Wed Sep 23 2009 - 08:26:29 CDT
>
>
>
> 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-l