Oracle DBMS_AQ_EXP_QUEUE_TABLES
Version 18.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Advanced Queuing Export Tables Management
AUTHID CURRENT_USER
Dependencies
ALL_QUEUES DBMS_AQ_SYS_EXP_INTERNAL OBJ$
DBMS_AQ_EXP_ZECURITY DBMS_AQ_SYS_IMP_INTERNAL USER$
DBMS_AQ_SYS_EXP_ACTIONS    
Documented No
First Available 19c
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
Subprograms
 
INSTANCE_CALLOUT
Undocumented dbms_aq_exp_queue_tables.instance_callout(
name    IN VARCHAR2,
schema  IN VARCHAR2,
prepost IN BINARY_INTEGER,
isdba   IN BINARY_INTEGER,
version IN VARCHAR2);
BEGIN
  dbms_aq_exp_queue_tables.instance_callout('UWEXP', USER, 32768, 1, '18.0');
END;
/
 
INSTANCE_INFO_EXP
Undocumented dbms_aq_exp_queue_tables.instance_info_exp(
name      IN  VARCHAR2,
schema    IN  VARCHAR2,
prepost   IN  BINARY_INTEGER,
isdba     IN  BINARY_INTEGER,
version   IN  VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
 nblock PLS_INTEGER;
 retVal VARCHAR2(30);
BEGIN
  retVal := dbms_aq_exp_queue_tables.instance_info_exp('UWEXP', USER, 32768, 1, '18.0', nblock);
  dbms_output.put_line(TO_CHAR(nblock));
END;
/
 
SCHEMA_CALLOUT
Undocumented dbms_aq_exp_queue_tables.schema_callout(
schema  IN VARCHAR2,
prepost IN BINARY_INTEGER,
isdba   IN BINARY_INTEGER,
version IN VARCHAR2);
SQL> exec dbms_aq_exp_queue_tables.schema_callout('C##SH', 0, 1, '18.0');

PL/SQL procedure successfully completed.
 
SCHEMA_INFO_EXP
Undocumented dbms_aq_exp_queue_tables.schema_info_exp(
schema    IN  VARCHAR2,
prepost   IN  BINARY_INTEGER,
isdba     IN  BINARY_INTEGER,
version   IN  VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
 retVal VARCHAR2(60);
 nblk BINARY_INTEGER;
BEGIN
  retVal := dbms_aq_exp_queue_tables.schema_info_exp('C##SH', 0, 1, '18.0', nblk);
  dbms_output.put_line('retVal: ' || retVal);
  dbms_output.put_line('New Block: ' || TO_CHAR(nblk));
END;
/

Related Topics
Built-in Functions
Built-in Packages
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMP_ZECURITY
What's New In 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx