Rem
Rem $Header: oraolap/admin/xoqdrop.sql /main/12 2009/11/17 14:22:05 glyon Exp $
Rem
Rem xoqdrop.sql
Rem
Rem Copyright (c) 2005, 2009, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      xoqdrop.sql -
Rem
Rem    DESCRIPTION
Rem
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       11/03/09 - more drops from olapimov.sql
Rem    akociube    04/08/09 - Add drop of dbms_cube_util
Rem    glyon       03/09/09 - Add drops of xoq_validate and interactionexecute
Rem    csperry     05/17/07 - Add drop of dbms_cube_advise
Rem    glyon       05/03/07 - drop dbms_cube and dbms_cune_exp
Rem    dbardwel    12/21/06 - remove AWMs /olap_data_security from xml db
Rem    wechen      12/06/06 - more drops from olapiboo.sql
Rem    wechen      11/14/06 - delete /OLAP_XDS
Rem    ilisansk    08/12/05 - removed drops from olapimdx.sql
REM    wechen      08/05/05 - remove SQLOLAPIException, OlapiBootstra &
REM                           OlapiHandshake, drop GenWstringSequence
Rem    wechen      07/21/05 - remove olapi*92010.sql
Rem    wechen      05/24/05 - wechen_txn115245
Rem    wechen      05/23/05 - Creation

--Drop dbms_cube_advise
drop package dbms_cube_advise;
drop package dbms_cube_advise_sec;
drop type coad_advice_t;
drop type coad_advice_rec;
drop sequence  DBMS_CUBE_ADVICE_SEQ$;

-- all DROPs from olapiboo.sql
DROP TYPE GenOLAPIException FORCE;
DROP PUBLIC SYNONYM OlapiHandshake2;
DROP PROCEDURE OlapiHandshake2;
DROP PUBLIC SYNONYM OlapiBootstrap2;
DROP FUNCTION OlapiBootstrap2;
DROP LIBRARY DBMS_OLAPI_LIB;
DROP TYPE GenInterfaceStub FORCE;
DROP TYPE GenInterfaceStubSequence FORCE;
DROP TYPE GenRawSequence FORCE;
DROP TYPE GenWstringSequence FORCE;
DROP PACKAGE dbms_cube;
DROP PACKAGE dbms_cube_exp;
DROP SEQUENCE OLAP_ATTRIBUTES_SEQ;
DROP SEQUENCE OLAP_DIMENSIONALITY_SEQ;
DROP SEQUENCE OLAP_DIM_LEVELS_SEQ;
DROP SEQUENCE OLAP_HIERARCHIES_SEQ;
DROP SEQUENCE OLAP_HIER_LEVELS_SEQ;
DROP SEQUENCE OLAP_MAPPINGS_SEQ;
DROP SEQUENCE OLAP_MEASURES_SEQ;
DROP SEQUENCE OLAP_MODELS_SEQ;
DROP SEQUENCE OLAP_ASSIGNMENTS_SEQ;
DROP SEQUENCE OLAP_CALCULATED_MEMBERS_SEQ;

-- all DROPs from olapilib.sql
DROP LIBRARY DBMS_OLAPI_LIB2;

-- all DROPs from olapimov.sql
DROP PUBLIC SYNONYM GV_Olapi_Session_History FORCE;
DROP PUBLIC SYNONYM V_Olapi_Session_History FORCE;
DROP PUBLIC SYNONYM GV_Olapi_Iface_Object_History FORCE;
DROP PUBLIC SYNONYM V_Olapi_Iface_Object_History FORCE;
DROP PUBLIC SYNONYM GV_Olapi_Iface_Op_History FORCE;
DROP PUBLIC SYNONYM V_Olapi_Iface_Op_History FORCE;
DROP PUBLIC SYNONYM GV_Olapi_Memory_Op_History FORCE;
DROP PUBLIC SYNONYM V_Olapi_Memory_Op_History FORCE;
DROP PUBLIC SYNONYM GV_Ksmhp FORCE;
DROP PUBLIC SYNONYM Olapi_History_Seq FORCE;
DROP PUBLIC SYNONYM Olapi_History FORCE;
DROP PUBLIC SYNONYM Olapi_Session_History FORCE;
DROP PUBLIC SYNONYM Olapi_Iface_Object_History FORCE;
DROP PUBLIC SYNONYM Olapi_Iface_Op_History FORCE;
DROP PUBLIC SYNONYM Olapi_Memory_Op_History FORCE;
DROP PUBLIC SYNONYM Olapi_Memory_Heap_History FORCE;
DROP PUBLIC SYNONYM DBMS_XSOQ FORCE;
DROP PUBLIC SYNONYM DBMS_XSOQ_UTIL FORCE;
DROP VIEW GV_Olapi_Session_History;
DROP VIEW V_Olapi_Session_History;
DROP VIEW GV_Olapi_Iface_Object_History;
DROP VIEW V_Olapi_Iface_Object_History;
DROP VIEW GV_Olapi_Iface_Op_History;
DROP VIEW V_Olapi_Iface_Op_History;
DROP VIEW GV_Olapi_Memory_Op_History;
DROP VIEW V_Olapi_Memory_Op_History;
DROP VIEW GV_Ksmhp;
DROP SEQUENCE Olapi_History_Seq;
DROP TABLE Olapi_History CASCADE CONSTRAINTS;
DROP TABLE Olapi_Session_History CASCADE CONSTRAINTS;
DROP TABLE Olapi_Iface_Object_History CASCADE CONSTRAINTS;
DROP TABLE Olapi_Iface_Op_History CASCADE CONSTRAINTS;
DROP TABLE Olapi_Memory_Op_History CASCADE CONSTRAINTS;
DROP TABLE Olapi_Memory_Heap_History CASCADE CONSTRAINTS;
DROP PROCEDURE OlapiHistoryRetention;
DROP TRIGGER OlapiStartupTrigger;
DROP TRIGGER OlapiShutdownTrigger;
DROP PACKAGE DBMS_XSOQ;
DROP PACKAGE DBMS_XSOQ_UTIL;

-- drop OLAPI_TRACE_USER role, it it exists
declare
  cursor xoqrole is select role from dba_roles where role = 'OLAPI_TRACE_USER';
  xoqrolename varchar2(30);
begin
  if not xoqrole%isopen then
    open xoqrole;
    fetch xoqrole into xoqrolename;
    if xoqrole%found then
      execute immediate 'DROP ROLE OLAPI_TRACE_USER';
    end if;
    close xoqrole;
  end if;
end;
/

-- all DROPs from dbmscbu.sql
DROP PUBLIC SYNONYM DBMS_CUBE_UTIL;
DROP PACKAGE DBMS_CUBE_UTIL;

-- all DROPs from generated olapidrp.sql
@@olapidrp.plb

-- all deletes from olapixds.sql
declare
 tmp boolean := false;
begin
 dbms_xdb.deleteresource('/OLAP_XDS', DBMS_XDB.DELETE_RECURSIVE_FORCE);
 dbms_xdb.deleteresource('/olap_data_security', DBMS_XDB.DELETE_RECURSIVE_FORCE); 
end;
/

-- drop validation procedure
drop procedure xoq_validate;

-- drop AWXML stuff
drop function interactionexecute;
drop package dbms_aw_xml;