QueryDB

begin dbms_aqadm.stop_queue(queue_name => 'username.tablename',wait =>{TRUE||FALSE}); end; /

resource busy and acquire with NOWAIT specified cause:- Resource interested is busy. action:- Retry if necessary.or can kill the session using the resource by using the following reference killing session

Identify the Session to be Killed SET LINESIZE 100 COLUMN spid FORMAT A10 COLUMN username FORMAT A10 COLUMN program FORMAT A45 SELECT s.inst_id, s.sid, s.serial#, p.spid, s.username, s.program FROM gv$session s JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id WHERE s.type != 'BACKGROUND'; ALTER SYSTEM KILL SESSION SQL> ALTER SYSTEM KILL SESSION 'sid,serial#'; SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

Use this procedure to find and kill a user's session: SQLPLUS> select sid, serial# from v$session where username = 'USER'; SQLPLUS> alter system kill session 'SID,SERIAL#';

no privilege to export string's table string Cause: An attempt was made to export another user's table. Only a database administrator can export another user's tables. Action: Ask your database administrator to do the export.