forked from oleksiivorobiov/oracle_oci_examples
-
Notifications
You must be signed in to change notification settings - Fork 0
/
aqdemo12.sql
54 lines (47 loc) · 1.11 KB
/
aqdemo12.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
Rem
Rem $Header: aqdemo12.sql 17-oct-2003.16:57:18 aahluwal Exp $
Rem
Rem aqdemo12.sql
Rem
Rem Copyright (c) 2003, Oracle Corporation. All rights reserved.
Rem
Rem NAME
Rem aqdemo12.sql - <one-line expansion of the name>
Rem
Rem DESCRIPTION
Rem Removes objects and users created by aqdemo09.sql.
Rem
Rem NOTES
Rem Run this script as SYS using SQLPLUS and type '@aqdemo12'.
Rem
Rem MODIFIED (MM/DD/YY)
Rem aahluwal 10/17/03 - aahluwal_create_arrenqdeq_demos
Rem aahluwal 10/07/03 - Created
Rem
SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100
set serveroutput on
set echo on
spool aqdemo12.log
rem ==========================================
rem Drop My_Queue_Tab Queue Table
rem ==========================================
DECLARE
BEGIN
dbms_output.put_line ('Dropping Queue Table my_queue_tab...');
dbms_aqadm.drop_queue_table
(
queue_table => 'aquser.my_queue_tab',
force => TRUE
);
dbms_output.put_line ('Dropped Queue Table my_queue_tab.');
END;
/
drop user aquser cascade
/
spool off