DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_ASSOCIATIONS

Object Details
Object Name: ALL_ASSOCIATIONS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All associations available to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_OWNER VARCHAR2 (128) Yes Owner of the object for which the association is being defined
OBJECT_NAME VARCHAR2 (128) Yes Object name for which the association is being defined
COLUMN_NAME VARCHAR2 (128)
Column name in the object for which the association is being defined
OBJECT_TYPE VARCHAR2 (9)
Schema type of the object - column, type, package or function
STATSTYPE_SCHEMA VARCHAR2 (128)
Owner of the statistics type
STATSTYPE_NAME VARCHAR2 (128)
Name of Statistics type which contains the cost, selectivity or stats funcs
DEF_SELECTIVITY NUMBER

Default Selectivity if any of the object
DEF_CPU_COST NUMBER

Default CPU cost if any of the object
DEF_IO_COST NUMBER

Default I/O cost if any of the object
DEF_NET_COST NUMBER

Default Networking cost if any of the object
INTERFACE_VERSION NUMBER

Version number of Statistics type interface implemented
MAINTENANCE_TYPE VARCHAR2 (14)
Whether it is system managed or user managed
Query Text

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


SELECT OBJECT_OWNER
,      OBJECT_NAME
,      COLUMN_NAME
,      OBJECT_TYPE
,      STATSTYPE_SCHEMA
,      STATSTYPE_NAME
,      DEF_SELECTIVITY
,      DEF_CPU_COST
,      DEF_IO_COST
,      DEF_NET_COST
,      INTERFACE_VERSION
,      MAINTENANCE_TYPE
FROM SYS.ALL_ASSOCIATIONS;

Dependencies

[top of page]

SYS.ALL_ASSOCIATIONS references the following:

SchemaSYS
TableASSOCIATION$
TableCOL$
TableOBJAUTH$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.ALL_ASSOCIATIONS is referenced by following:

SchemaPUBLIC
SynonymALL_ASSOCIATIONS