Rem
Rem $Header: catnohs.sql 26-mar-97.11:10:36 jdraaije Exp $
Rem
Rem catnohs.sql
Rem
Rem  Copyright (c) Oracle Corporation 1997. All Rights Reserved.
Rem
Rem    NAME
Rem
Rem      catnohs.sql - Drop HS data dictionary tables & views
Rem
Rem    DESCRIPTION
Rem      This SQL script drops all tables and views created for the
Rem      heterogeneous option by caths.sql.
Rem
Rem    NOTES
Rem      This script must be run while connected as SYS or INTERNAL.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    jdraaije    03/26/97 - Name consistency: ho => hs
Rem    pravelin    11/22/96 - Resynchronize this script with catho.sql updates
Rem    pravelin    06/26/96 - Drop HS data dictionary tables & views
Rem    pravelin    06/26/96 - Created
Rem


drop role hs_admin_role;
drop table hs$_fds_class cascade constraints; 
drop sequence hs$_fds_class_s; 
drop view hs_fds_class; 
drop table hs$_fds_inst cascade constraints; 
drop sequence hs$_fds_inst_s; 
drop view hs_fds_inst;
drop table hs$_base_caps cascade constraints; 
drop view hs_base_caps;
drop table hs$_class_caps cascade constraints; 
drop sequence hs$_class_caps_s;
drop view hs_class_caps;
drop table hs$_inst_caps cascade constraints; 
drop sequence hs$_inst_caps_s; 
drop view hs_inst_caps;
drop table hs$_base_dd cascade constraints; 
drop sequence hs$_base_dd_s; 
drop view hs_base_dd;
drop table hs$_class_dd cascade constraints; 
drop sequence hs$_class_dd_s; 
drop view hs_class_dd;
drop table hs$_inst_dd cascade constraints; 
drop sequence hs$_inst_dd_s; 
drop view hs_inst_dd;
drop table hs$_class_init cascade constraints; 
drop sequence hs$_class_init_s; 
drop view hs_class_init;
drop table hs$_inst_init cascade constraints; 
drop sequence hs$_inst_init_s; 
drop view hs_inst_init;
drop table hs$_external_objects cascade constraints; 
drop sequence hs$_external_objects_s;
drop view hs_external_objects;
drop table hs$_granted_users cascade constraints;
drop sequence hs$_granted_users_s;
drop table hs$_privileges cascade constraints;
drop sequence hs$_privileges_s;
drop table hs$_access_grantees cascade constraints;
drop table hs$_create_grantees cascade constraints;
drop view hs_external_object_privileges;
drop view hs_external_user_privileges;
drop view hs_all_caps;
drop view hs_all_dd;
drop view hs_all_inits;
drop package dbms_hs;
drop package dbms_hs_extproc;
drop package dbms_hs_alt;
drop package dbms_hs_chk;
drop package dbms_hs_utl;
drop public synonym hs_fds_class;
drop public synonym hs_fds_inst;
drop public synonym hs_base_caps;
drop public synonym hs_class_caps;
drop public synonym hs_inst_caps;
drop public synonym hs_base_dd;
drop public synonym hs_class_dd;
drop public synonym hs_inst_dd;
drop public synonym hs_class_init;
drop public synonym hs_inst_init;
drop public synonym hs_external_objects;
drop public synonym hs_external_object_privileges;
drop public synonym hs_external_user_privileges;
drop public synonym hs_all_caps;
drop public synonym hs_all_dd;
drop public synonym hs_all_inits;
drop public synonym dbms_hs;
drop public synonym dbms_hs_extproc;

