Rem
Rem $Header: analyze_rule.sql 20-sep-2006.02:12:23 chli Exp $
Rem
Rem analyze_rule.sql
Rem
Rem Copyright (c) 2002, 2006, Oracle. All rights reserved.
Rem
Rem    NAME
Rem      analyze_rule.sql - analyze the result of SYS.RULE$ table
Rem
Rem    DESCRIPTION
Rem      analyze the scanner result of SYS.RULE$ 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.RULE$
rem *****************************************************************
Prompt Table: SYS.RULE$
prompt Error: CONVERTIBLE DATA

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

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

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