Rem drv:
Rem
Rem $Header: policy_schema_downgrade.sql 03-aug-2005.08:04:22 niramach Exp $
Rem
Rem policy_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.
Rem
Rem NAME
Rem policy_schema_downgrade.sql - Downgrade scripts for policy schema
Rem
Rem DESCRIPTION
Rem It has the creation of V1 policy schema and deletion of V2 policy
Rem schema.
Rem
Rem NOTES
Rem
Rem
Rem MODIFIED (MM/DD/YY)
Rem niramach 08/03/05 - niramach_bugfix-4527462
Rem niramach 08/01/05 - Moved the file from v102010 to v102020 and changed
Rem - links.
Rem chyu 07/19/05 - modifying the new rep manager header
Rem niramach 04/29/05 - niramach_bug-4293674
Rem niramach 04/26/05 - Created
Rem
DEFINE GUID_RAW_LENGTH = 16
rem -------------------------------------------------------------------------------
rem The following defines are obsolete with GC Rel 2. They had been used to
rem support the Version 1 policy framework; that is, the framework prior to
rem the metric/policy unification effort.
rem
rem The following defines are used for column sizes in the policy tables and policy
rem types. The prefix 'P_' keeps them separate from other defines.
DEFINE P_NAME_LENGTH = 128
DEFINE P_DESCRIPTION_LENGTH = 2000
DEFINE P_SHORT_DESCRIPTION_LENGTH = 500
DEFINE P_CAPTION_LENGTH = 100
DEFINE P_VERSION_LENGTH = 50
DEFINE P_TARGET_TYPE_LENGTH = 100
DEFINE P_RULE_TYPE_LENGTH = 100
DEFINE P_CATEGORY_LENGTH = 100
DEFINE P_LARGE_VARCHAR_LENGTH = 4000
DEFINE P_REASONABLE_NUMBER_LENGTH = 10
DEFINE P_SQL_NAME_LENGTH = 31;
DEFINE P_VALUE_LENGTH = 1024;
DEFINE P_FILTER_OP_LENGTH = 10;
DEFINE P_SEVERITY_LENGTH = 10;
DEFINE P_RULE_NAME_LENGTH = 128
DEFINE P_PARAM_NAME_LENGTH = 128
DEFINE P_ATTRIBUTE_NAME_LENGTH = 31
DEFINE P_TARGET_NAME_LENGTH = 100
DEFINE P_PARAM_VALUE_LENGTH = 1024;
DEFINE P_ATTRIBUTE_VALUE_LENGTH = 1024
DEFINE P_COLUMN_NAME_LENGTH = &P_SQL_NAME_LENGTH
DEFINE P_Y_N_LENGTH = 1
DEFINE P_SNAPSHOT_TYPE_LENGTH = 64
DEFINE P_AUTHOR_LENGTH = 128
DEFINE P_URL_LENGTH = 2000
DEFINE P_DISPLAY_ID_LENGTH = 128
DEFINE P_CLEAR = 0
@&EM_SQL_ROOT/core/v102020/policy/policy_types_downgrade.sql
@&EM_SQL_ROOT/core/v102020/policy/policy_tables_downgrade.sql
@&EM_SQL_ROOT/core/v102020/policy/policy_indexes_downgrade.sql