--
-- $Header: ocmrepdrp.sql 15-sep-00.06:48:41 shuberma Exp $
--
-- ocmrepdrp.sql
--
--  Copyright (c) Oracle Corporation 2000. All Rights Reserved.
--
--    NAME
--      ocmrepdrp.sql - Oracle Change Manager repository drop sql script.
--
--    DESCRIPTION
--      Used to Drop the latest version of change manager's repository objects.
--
--    NOTES
--      <other useful comments, qualifications, etc.>
--
--    MODIFIED   (MM/DD/YY)
--    shuberma    09/15/00 - New drop script.
--    shuberma    09/15/00 - Created
--
drop table vbz$change_plans cascade constraints;
drop table vbz$comparisons cascade constraints;
drop table vbz$comparison_results cascade constraints;
drop table vbz$db_obj_names cascade constraints;
drop table vbz$destinations cascade constraints;
drop table vbz$directives cascade constraints;
drop table vbz$edited_scripts cascade constraints;
drop table vbz$exemplars cascade constraints;
drop table vbz$history cascade constraints;
drop table vbz$impact_log cascade constraints;
drop table vbz$object_grants cascade constraints;
drop table vbz$output_log cascade constraints;
drop table vbz$role_grants cascade constraints;
drop table vbz$schemamaps cascade constraints;
drop table vbz$scripts cascade constraints;
drop table vbz$sys_priv_grants cascade constraints;
drop table vbz$version cascade constraints;
drop table vbz$ex_updates cascade constraints;

drop sequence vbz$db_obj_names_seq;
drop sequence vbz$rep_obj_id_seq;
drop sequence vbz$history_seq;