Oracle DBMS_AQ_EXP_DEQUEUELOG_TABLES
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Export AQ Dequeue Log Tables
AUTHID CURRENT_USER
Dependencies
DBMS_AQ_EXP_ZECURITY DBMS_AQ_SYS_EXP_ACTIONS  
Documented No
First Available 11.2.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
 
INSTANCE_INFO_EXP
Undocumented dbms_aq_exp_cmt_time_tables(
name      IN  VARCHAR2,
schema    IN  VARCHAR2,
prepost   IN  BINARY_INTEGER,
isdba     IN  BINARY_INTEGER,
version   IN  VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
SELECT owner, queue_table, type
FROM dba_queue_tables
ORDER BY 1,2;

set serveroutput on

SQL> DECLARE
  2   nblk   BINARY_INTEGER;
  3   retVal VARCHAR2(4096);
  4  BEGIN
  5    retVal := dbms_aq_exp_dequeuelog_tables.instance_info_exp('AQ_EVENT_TABLE', 'SYS', 1, 1, '12.2.0.1.0', nblk);
  6
  7    dbms_output.put_line('New Block: ' || TO_CHAR(nblk));
  8    dbms_output.put_line('Return Value: ' || retVal);
  9  END;
 10  /
New Block: 1
Return Value: DECLARE dbvers varchar2(20); compat varchar2(20); BEGIN execute immediate 'begin
sys.DBMS_UTILITY.DB_VERSION(:1, :2); end;' using out dbvers, out compat; IF
(sys.dbms_logrep_exp.version_var2_2_number(dbvers) >= sys.dbms_logrep_exp.version_var2_2_number('11.2')) THEN
execute immediate 'begin SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_DEQUEUELOG_TABLE(''AQ_EVENT_TABLE''); end;'; ELSE execute
immediate 'ALTER SESSION SET EVENTS ''10851 trace name context forever, level 1'''; execute immediate 'DROP TABLE
"SYS"."AQ_EVENT_TABLE"'; END IF; END;

Related Topics
Advanced Queuing Demo 1
Advanced Queuing RAC Demo
DBMS_ALERT
DBMS_AQ
DBMS_AQADM
DBMS_AQELM
DBMS_AQINV
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_IMP_ZECURITY
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved