DBA_OBJ_COLATTRS

Description of object columns and attributes contained in all tables in the database

Columns
   ___________________________
 
   OWNER
      Owner of the table
   TABLE_NAME
      Name of the table containing the object column or attribute
   COLUMN_NAME
      Fully qualified name of the object column or attribute
   SUBSTITUTABLE
      Indication of whether the column is substitutable or not