Rem
Rem $Header: policy_tables_upgrade.sql 29-apr-2005.00:35:05 niramach Exp $
Rem
Rem policy_tables_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      policy_tables_upgrade.sql - Upgrade script for policy tables
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    niramach    04/29/05 - niramach_bug-4293674
Rem    niramach    04/26/05 - Created
Rem

--Drop all the V1(obsolete) policy tables

DROP TABLE MGMT_POLICY_RULE_DEF_COLUMNS;
DROP TABLE MGMT_POLICY_RULE_DEF_PARAMS;
DROP TABLE MGMT_POLICY_RULE;
DROP TABLE MGMT_POLICY_PARAMS;
DROP TABLE MGMT_POLICY_RULE_CRITERIA;
DROP TABLE MGMT_POLICY_TARGET_CRITERIA;
DROP TABLE MGMT_POLICY_VIOLATION_VALUES;
DROP TABLE MGMT_POLICY_VIOLATION_ROWS;
DROP TABLE MGMT_POLICY_VIOLATIONS;
DROP TABLE MGMT_POLICY_SNAPSHOT_CRITERIA;
DROP TABLE MGMT_POLICY_GROUP;
DROP TABLE MGMT_POLICY_ERRORS;


--Create V2 (new) policy tables.
@&EM_SQL_ROOT/core/v102010/policy/policy_tables.sql