select DISTINCT table_name ,OWNER from dba_tab_columns where OWNER NOT IN ('SYS','SYSTEM') AND DATA_TYPE <>'LONG' Regards, Mohammed On Wed, Sep 23, 2009 at 6:41 PM, Helen Mitchell <HelenJMitchell@xxxxxxxxxxx>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. >