Rem drv: <create type="post_creation" pos="esm/esm_post_createion_cond.sql+"/>
Rem
Rem $Header: default_policy_setup.sql 20-jul-2005.08:03:59 chyu 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 - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem
Rem      !!!!!!! Please update UPGRADE script when updates are made. !!!!!!!
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chyu        07/20/05 - modifying the type to post_creation 
Rem    gsbhatia    07/11/05 - New repmgr header impl 
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

@&EM_SQL_ROOT/db/latest/policy/config_metric_setup.sql
@&EM_SQL_ROOT/db/latest/policy/storage_metric_setup.sql
@&EM_SQL_ROOT/db/latest/policy/config_policy_setup.sql
@&EM_SQL_ROOT/db/latest/policy/storage_policy_setup.sql
commit;