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>


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 exclude
ORDER 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:

>
>
>
> 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
Received on Wed Sep 23 2009 - 08:26:29 CDT

Original text of this message