Re: need help with script

From: Daniel Fink <>
Date: Wed, 23 Sep 2009 07:26:29 -0600
Message-ID: <>

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

Daniel Fink

Daniel Fink

Oracle Blog

Lost Data?

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

Original text of this message