Rem
Rem $Header: syshist_downgrade.sql 03-jul-2006.14:50:07 vkarpura Exp $
Rem
Rem syshist_downgrade.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      syshist_downgrade.sql - <one-line expansion of the name>
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    vkarpura    04/14/06 - Creation
Rem    vkarpura    04/14/06 - Creation
Rem    vkarpura    04/14/06 - Created
Rem

--
-- Generated by generateDropTables.pl at Fri Apr 14 14:38:55 2006
--

-- Uncomment the following line to see the commands during the script execution
-- SET ECHO ON 

-- Do not use substitution variables in this script so that there is no
-- additional restrictions on the string values that are being inserted (such as ampersand 
-- being interpreted specially by SQLPlus).
SET DEFINE OFF 

--------------------------------------------
-- Table (re)creation statements based on metadata Service Dependency  for target type generic_system and snapshot type system_change_config
-- Please REVIEW the table (re)creation statements below and modify them if necessary. Examples: 
--   (1) You meant for a TABLE tag in the metadata to represent a view. Then, remove the corresponding drop-table / create-table statements.
--   (2) Generated PRIMARY KEY constraints are supposed to be uniqueness constraints instead.
--   (3) You want to impose additional constraints on the tables.
--------------------------------------------
-- Drop tables

DROP TABLE "MGMT_SYSTEM_CHANGES";

--------------------------------------------

SET DEFINE ON