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

VIEW: SYS.CDB_ASSOCIATIONS

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

All associations in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_OWNER VARCHAR2 (30) Yes Owner of the object for which the association is being defined
OBJECT_NAME VARCHAR2 (30) Yes Object name for which the association is being defined
COLUMN_NAME VARCHAR2 (30)
Column name in the object for which the association is being defined
OBJECT_TYPE VARCHAR2 (9)
Schema type of the object - table, type, package or function
STATSTYPE_SCHEMA VARCHAR2 (30)
Owner of the statistics type
STATSTYPE_NAME VARCHAR2 (30)
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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_ASSOCIATIONS;

Dependencies

[top of page]

SYS.CDB_ASSOCIATIONS does not reference any database object

SYS.CDB_ASSOCIATIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_ASSOCIATIONS