[Home] [Help] [Dependency Information]
Object Name: | ASSOCIATION$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ASSOC1 | NORMAL | UNIQUE | SYSTEM |
OBJ#
INTCOL# |
ASSOC2 | NORMAL | NONUNIQUE | SYSTEM | STATSTYPE# |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | Yes | ||
PROPERTY | NUMBER | Yes | ||
INTCOL# | NUMBER | |||
STATSTYPE# | NUMBER | |||
DEFAULT_SELECTIVITY | NUMBER | |||
DEFAULT_CPU_COST | NUMBER | |||
DEFAULT_IO_COST | NUMBER | |||
DEFAULT_NET_COST | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
INTERFACE_VERSION# | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, PROPERTY
, INTCOL#
, STATSTYPE#
, DEFAULT_SELECTIVITY
, DEFAULT_CPU_COST
, DEFAULT_IO_COST
, DEFAULT_NET_COST
, SPARE1
, SPARE2
, INTERFACE_VERSION#
FROM SYS.ASSOCIATION$;
SYS.ASSOCIATION$ does not reference any database object
SYS.ASSOCIATION$ is referenced by following:
|
|
|