Rem
Rem $Header: catnoqueue.sql 20-nov-98.19:36:41 ryaseen Exp $
Rem
Rem catnoqueue.sql
Rem
Rem  Copyright (c) Oracle Corporation 1997, 1998. All Rights Reserved.
Rem
Rem    NAME
Rem      catnoqueue.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    ryaseen     11/20/98 - splitting dbms_aqadm
Rem    mkamath     04/27/98 - drop sys.aq$_schedules
Rem    ryaseen     04/13/98 - load package dbms_prvtaqis
Rem    ryaseen     04/10/98 - move subscribers, rules table to user schema
Rem    ryaseen     04/07/98 - incorporate sys.aq$_rules
Rem    ryaseen     04/02/98 - incorporate sys.aq$_queue_subscribers
Rem    nbhatt      03/17/98 - drop aq$_queue_table_affinities
Rem    arsaxena    09/24/97 - remove sys.aq$_message_types
Rem    nbhatt      08/22/97 - remove sys.aq$_queue_statistics
Rem    arsaxena    07/25/97 -
Rem    schandra    04/30/97 - compensates effects of catqueue.sql
Rem    schandra    04/30/97 - Created
Rem


drop view USER_QUEUES;
drop public synonym USER_QUEUES;

drop view DBA_QUEUES;

drop view DBA_QUEUE_SCHEDULES;
drop view USER_QUEUE_SCHEDULES;

drop view USER_QUEUE_TABLES;
drop public synonym USER_QUEUE_TABLES;

drop view DBA_QUEUE_TABLES;

drop table system.aq$_queue_tables cascade constraints;
drop table system.aq$_queues cascade constraints;
drop table system.aq$_schedules cascade constraints;
drop table sys.aq$_schedules cascade constraints;
drop table sys.aq$_queue_table_affinities;
drop table sys.aq$_queue_statistics;
drop table sys.aq$_message_types;

drop type sys.aq$_history;
drop type sys.aq$_dequeue_history_t;
drop type sys.aq$_recipients;
drop type sys.aq$_subscribers;
drop type sys.aq$_dequeue_history;
drop type sys.aq$_agent;
drop type sys.aq$_notify_msg;


drop SEQUENCE system.aq$_qidseq;
drop SEQUENCE sys.aq$_chainseq;
drop LIBRARY dbms_aq_lib;
drop package dbms_aq;
drop package dbms_aqadm;
drop package dbms_prvtaqis;
