More on Oracle Object Management Scripts

(We marked visited pages blue)
  • Script Drop all temp datafiles
  • Script to List all Datafiles and Tablespaces
  • Object Dependency Report
  • 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');


    Leave a comment or a question in the comment area bellow if you fell like


    Be a sport and

    Search

    Loading... Please wait

    Subscribe to our Newsletter

    Be a sport and

    x