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

TABLE: SYS.COLLECTION$

Object Details
Object Name: COLLECTION$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 0
PCT Used: 0
Indexes
Index Type Uniqueness Tablespace Column
I_COLLECTION1 NORMAL UNIQUE TablespaceSYSTEM ColumnTOID
ColumnVERSION#
ColumnPACKAGE_OBJ#
Columns
Name Datatype Length Mandatory Comments
TOID RAW (16) Yes
VERSION# NUMBER
Yes
COLL_TOID RAW (16) Yes
COLL_VERSION# NUMBER
Yes
ELEM_TOID RAW (16) Yes
ELEM_VERSION# NUMBER
Yes
PROPERTIES NUMBER
Yes
CHARSETID NUMBER

CHARSETFORM NUMBER

LENGTH NUMBER

PRECISION NUMBER

SCALE NUMBER

UPPER_BOUND NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SYNOBJ# NUMBER

COLL_NAME VARCHAR2 (128)
PACKAGE_OBJ# NUMBER

Query Text

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


SELECT TOID
,      VERSION#
,      COLL_TOID
,      COLL_VERSION#
,      ELEM_TOID
,      ELEM_VERSION#
,      PROPERTIES
,      CHARSETID
,      CHARSETFORM
,      LENGTH
,      PRECISION
,      SCALE
,      UPPER_BOUND
,      SPARE1
,      SPARE2
,      SPARE3
,      SYNOBJ#
,      COLL_NAME
,      PACKAGE_OBJ#
FROM SYS.COLLECTION$;

Dependencies

[top of page]

SYS.COLLECTION$ does not reference any database object

SYS.COLLECTION$ is referenced by following:

SchemaSYS
ViewALL_COLL_TYPES
ViewALL_NESTED_TABLES
ViewALL_PLSQL_COLL_TYPES
ViewALL_TRIGGER_COLS
ViewALL_TSTZ_TAB_COLS
ViewALL_VARRAYS
ViewDBA_COLL_TYPES
ViewDBA_NESTED_TABLES
ViewDBA_PLSQL_COLL_TYPES
ViewDBA_TRIGGER_COLS
ViewDBA_TSTZ_TAB_COLS
ViewDBA_VARRAYS
Package BodyDBMS_PICKLER - show dependent code
Package BodyDBMS_REPCAT_UTL4 - show dependent code
ViewKU$_ALL_TSLTZ_TAB_COLS
ViewKU$_COLLECTION_VIEW
ViewUSER_COLL_TYPES
ViewUSER_NESTED_TABLES
ViewUSER_PLSQL_COLL_TYPES
ViewUSER_TRIGGER_COLS
ViewUSER_TSTZ_TAB_COLS
ViewUSER_VARRAYS