--
-- $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
--

begin
  execute immediate 'drop table vbz$change_plans cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$comparisons cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$comparison_results cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$db_obj_names cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$destinations cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$directives cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$edited_scripts cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$exemplars cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$history cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$impact_log cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$object_grants cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$output_log cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$role_grants cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$schemamaps cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$scripts cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$sys_priv_grants cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$version cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop table vbz$ex_updates cascade constraints';
exception
  when others
  then
    null;
end;
/
commit;


begin
  execute immediate 'drop sequence vbz$db_obj_names_seq';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop sequence vbz$rep_obj_id_seq';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop sequence vbz$history_seq';
exception
  when others
  then
    null;
end;
/
commit;