Rem
Rem $Header: analyze_source.sql 04-aug-2003.11:16:19 ywu Exp $
Rem
Rem analyze_source.sql
Rem
Rem Copyright (c) 2002, 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      analyze_source.sql - analyze the result of SYS.SOURCE$ table
Rem
Rem    DESCRIPTION
Rem      analyze the scanner result of SYS.SOURCE$ table
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    ywu         08/01/03 - fix a typo
Rem    ywu         10/24/02 - ywu_codept3
Rem    ywu         10/23/02 - Created
Rem

rem *****************************************************************
rem  CONVERITIBLE DATA IN SYS.SOURCE$
rem *****************************************************************
Prompt Table: SYS.SOURCE$
prompt Error: CONVERTIBLE DATA

select owner, object_name, object_type, count(*) CONVERITBLE
 from all_objects, sys.source$
 where object_id = obj#
 and sys.source$.rowid in 
(select data_rowid from csmv$errors where owner_name='SYS'
  and table_name='SOURCE$' and error_type='CONVERTIBLE'
)
group by all_objects.owner, all_objects.object_name, all_objects.object_type
/

rem *****************************************************************
rem  EXCEPTIONAL DATA IN SYS.SOURCE$
rem *****************************************************************
Prompt Table: SYS.SOURCE$
prompt Error: EXCEPTIONAL DATA

select owner, object_name, object_type, count(*) EXCEPTIONAL
 from all_objects, sys.source$
 where object_id = obj#
 and sys.source$.rowid in 
(select data_rowid from csmv$errors where owner_name='SYS'
  and table_name='SOURCE$' and error_type='DATA_LOSS'
)
group by all_objects.owner, all_objects.object_name, all_objects.object_type
/