[Home] [Help] [Dependency Information]

TABLE: SYS.AQ$_QUEUE_TABLE_AFFINITIES

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: AQ$_QTABLE_AFFINITIES_PK

1. TABLE_OBJNO

Indexes

Index	Type	Uniqueness	Tablespace	Column
AQ$_QTABLE_AFFINITIES_PK	NORMAL	UNIQUE	SYSTEM	TABLE_OBJNO
I1_QUEUE_TABLE_AFFINITIES	NORMAL	NONUNIQUE	SYSTEM	OWNER_INSTANCE TABLE_OBJNO

Columns

Query Text

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

SELECT TABLE_OBJNO
,      PRIMARY_INSTANCE
,      SECONDARY_INSTANCE
,      OWNER_INSTANCE
FROM SYS.AQ$_QUEUE_TABLE_AFFINITIES;

Dependencies

[top of page]

SYS.AQ$_QUEUE_TABLE_AFFINITIES does not reference any database object

SYS.AQ$_QUEUE_TABLE_AFFINITIES is referenced by following:

SYS

ALL_QUEUE_TABLES

DBA_QUEUE_TABLES

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_PRVTAQIP - show dependent code

KU$_QUEUE_TABLE_VIEW

USER_QUEUE_TABLES