[Home] [Help] [Dependency Information]

TABLE: SYSTEM.AQ$_QUEUE_TABLES

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: AQ$_QUEUE_TABLES_PRIMARY

1. OBJNO

Indexes

Index	Type	Uniqueness	Tablespace	Column
AQ$_QUEUE_TABLES_PRIMARY	NORMAL	UNIQUE	SYSTEM	OBJNO
I1_QUEUE_TABLES	NORMAL	NONUNIQUE	SYSTEM	OBJNO SCHEMA FLAGS

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT SCHEMA
,      NAME
,      UDATA_TYPE
,      OBJNO
,      FLAGS
,      SORT_COLS
,      TABLE_COMMENT
,      TIMEZONE
FROM SYSTEM.AQ$_QUEUE_TABLES;

Dependencies

[top of page]

SYSTEM.AQ$_QUEUE_TABLES does not reference any database object

SYSTEM.AQ$_QUEUE_TABLES is referenced by following:

SYS

ALL_DEQUEUE_QUEUES

ALL_INT_DEQUEUE_QUEUES

ALL_QUEUES

ALL_QUEUE_PUBLISHERS

ALL_QUEUE_SUBSCRIBERS

ALL_QUEUE_TABLES

DBA_QUEUES

DBA_QUEUE_PUBLISHERS

DBA_QUEUE_SUBSCRIBERS

DBA_QUEUE_TABLES

DBMS_APPLY_ERROR - show dependent code

DBMS_AQADM_SYS - show dependent code

DBMS_AQ_IMPORT_INTERNAL - show dependent code

DBMS_AQ_SYS_EXP_ACTIONS - show dependent code

DBMS_AQ_SYS_EXP_INTERNAL - show dependent code

DBMS_AQ_SYS_IMP_INTERNAL - show dependent code

DBMS_LOGREP_UTIL - show dependent code

DBMS_PRVTAQIM - show dependent code

DBMS_PRVTAQIP - show dependent code

DBMS_PRVTAQIS - show dependent code

KU$_QUEUES_VIEW

KU$_QUEUE_TABLE_VIEW

USER_QUEUES

USER_QUEUE_PUBLISHERS

USER_QUEUE_SUBSCRIBERS

USER_QUEUE_TABLES

_ALL_QUEUE_CACHED_MESSAGES

_ALL_QUEUE_SCHEDULES

_DBA_QUEUE_SCHEDULES

_DBA_QUEUE_SCHEDULES_COMPAT

_DBA_QUEUE_STATS1

_DBA_STREAMS_COMPONENT

_USER_QUEUE_SCHEDULES

_USER_QUEUE_SCHEDULES_COMPAT