Script to list all your tables with LOB, LONG and LONG RAW data types in ORacle

The Script will create a reports of your tables with LOB, LONG and LONG RAW data types. You can do per schema(just remove the comment and provide the schema) or by entire instance.

<code class="sql">

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE
  FROM dba_tab_columns
 WHERE
 -- OWNER = '&OWNER' AND
  data_type in ('CLOB', 'BLOB', 'LONG', 'LONG RAW', 'NCLOB');