Rem drv:
Rem
Rem $Header: default_policy_setup.sql 09-sep-2005.15:17:14 rreilly Exp $
Rem
Rem default_policy_setup.sql
Rem
Rem Copyright (c) 2003, 2005, Oracle. All rights reserved.
Rem
Rem NAME
Rem default_policy_setup.sql -
Rem
Rem DESCRIPTION
Rem
Rem
Rem NOTES
Rem
Rem !!!!!!! Please update UPGRADE script when updates are made. !!!!!!!
Rem
Rem MODIFIED (MM/DD/YY)
Rem rreilly 09/09/05 - bug4602294 due to core4583478 change can no longer run
Rem beta scripts
Rem chyu 07/12/05 - adding the new rep manager upgrade header
Rem xchen 06/07/05 - bug 4411021 upgrade changes for beta
Rem rreilly 04/27/05 - rreilly_bug-4294486
Rem rreilly 04/22/05 - make sure people update the upgrade scripts
Rem rreilly 02/10/05 - call broken out policy scripts
Rem mnihalan 01/17/05 - Exclude system from TBSP_SEGSPACE_MGMT
Rem rreilly 08/12/04 - bug 3264676 remove Invalid Objects policy
Rem rreilly 07/20/04 - bug 3763983 ignore __ hidden params
Rem rreilly 06/07/04 - add asm ( osm ) policies
Rem rreilly 04/29/04 - add additional STATISTICS_LEVEL policy check and
Rem change priority
Rem rreilly 04/28/04 - remove Use of Unlimited Autoextention policy
Rem rreilly 03/19/04 - change sga and pga link
Rem rreilly 03/15/04 - Add storage policies
Rem rreilly 03/11/04 - add configuration init param policies
Rem pbantis 01/08/04 - Remove Insufficient Recovery Area Size policy
Rem dsahrawa 12/09/03 - Bug 3105681 - remove non 7 bit ascii char
Rem pbantis 11/24/03 - Bug 3265469 - fix queries for RAC
Rem sbadrina 11/17/03 - bug 3260865 - add ncomp policy rule
Rem pbantis 11/06/03 - Add Recovery links
Rem pbantis 10/31/03 - Fix sql statements for RAC
Rem abodge 10/24/03 - Move some rules from Config to Storage
Rem abodge 10/24/03 - Change wording
Rem abodge 10/17/03 - Exclude clusters from segment checks
Rem abodge 10/15/03 - Fix URLs
Rem xshen 10/03/03 - oracle_dbconfig and oracle_racconfig
Rem xshen 10/02/03 - rename dbconfig snapshot type name
Rem abodge 09/30/03 - Enhance mixed-segment-types check
Rem abodge 09/25/03 - Rework storage policy rule
Rem groyal 09/18/03 - Change 'insufficient' policy rules
Rem abodge 09/10/03 - Add Tablespace to User policies
Rem abodge 09/09/03 - Add java classes to inv objects rule
Rem abodge 09/08/03 - Fix Objects snap item
Rem abodge 09/07/03 - Add Objects policy, Inv Objs rule
Rem sbadrina 08/27/03 - add cancelurl param to db object destinations
Rem xshen 09/02/03 - adding missing newline at eof
Rem xshen 09/02/03 - exempt rbs in system tbsp ck if auto undo mode
Rem abodge 08/22/03 - Revise storage policy wording
Rem abodge 08/20/03 - More rework
Rem abodge 08/14/03 - Rework rec seg rule
Rem groyal 08/04/03 - Uppercase categories
Rem shuberma 07/28/03 - Change as per Gaylen's request for OUW
Rem groyal 07/17/03 - Make changes to column definitions
Rem abodge 06/17/03 - Work on storage rules
Rem xshen 06/16/03 - modify config rule uniform dictionary tbsp
Rem groyal 06/11/03 - A couple of tweaks
Rem groyal 06/10/03 - Add rac support
Rem groyal 06/06/03 - Add onrefresh evaluation
Rem groyal 06/05/03 - groyal_policy_0604
Rem groyal 06/05/03 - Created
Rem
-- SET ECHO ON
-- A 10.2GC change in core code has added stricter checks to metrics
-- that are added to the repository. This new code causes these
-- beta scripts to fail, and therefor upgrade fails. The issue does
-- not exist in v102020 and all metrics and policies are being
-- recreated there, so the beta scripts are being commented out.
-- DO NOT ADD THESE SCRIPTS BACK, UPGRADE WILL FAIL!
--
-- @&EM_SQL_ROOT/db/v102010/policy/config_metric_setup.sql
-- @&EM_SQL_ROOT/db/v102010/policy/storage_metric_setup.sql
-- @&EM_SQL_ROOT/db/v102010/policy/config_policy_setup.sql
-- @&EM_SQL_ROOT/db/v102010/policy/storage_policy_setup.sql
-- commit;