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

TABLE: SYS.ATTRIBUTE$

Object Details
Object Name: ATTRIBUTE$
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_ATTRIBUTE1 NORMAL UNIQUE TablespaceSYSTEM ColumnTOID
ColumnVERSION#
ColumnNAME
I_ATTRIBUTE2 NORMAL UNIQUE TablespaceSYSTEM ColumnTOID
ColumnVERSION#
ColumnATTRIBUTE#
Columns
Name Datatype Length Mandatory Comments
TOID RAW (16) Yes
VERSION# NUMBER
Yes
NAME VARCHAR2 (128) Yes
ATTRIBUTE# NUMBER
Yes
ATTR_TOID RAW (16) Yes
ATTR_VERSION# NUMBER
Yes
PROPERTIES NUMBER
Yes
CHARSETID NUMBER

CHARSETFORM NUMBER

LENGTH NUMBER

PRECISION# NUMBER

SCALE NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

EXTERNNAME VARCHAR2 (4000)
SETTER NUMBER

GETTER NUMBER

SYNOBJ# NUMBER

XFLAGS NUMBER

SPARE4 NUMBER

SPARE5 NUMBER

Query Text

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


SELECT TOID
,      VERSION#
,      NAME
,      ATTRIBUTE#
,      ATTR_TOID
,      ATTR_VERSION#
,      PROPERTIES
,      CHARSETID
,      CHARSETFORM
,      LENGTH
,      PRECISION#
,      SCALE
,      SPARE1
,      SPARE2
,      SPARE3
,      EXTERNNAME
,      SETTER
,      GETTER
,      SYNOBJ#
,      XFLAGS
,      SPARE4
,      SPARE5
FROM SYS.ATTRIBUTE$;

Dependencies

[top of page]

SYS.ATTRIBUTE$ does not reference any database object

SYS.ATTRIBUTE$ is referenced by following:

SchemaSYS
ViewALL_PLSQL_TYPE_ATTRS
ViewALL_SQLJ_TYPE_ATTRS
ViewALL_TRIGGER_COLS
ViewALL_TSTZ_TAB_COLS
ViewALL_TYPE_ATTRS
ViewDBA_PLSQL_TYPE_ATTRS
ViewDBA_SQLJ_TYPE_ATTRS
ViewDBA_TRIGGER_COLS
ViewDBA_TSTZ_TAB_COLS
ViewDBA_TYPE_ATTRS
Package BodyDBMS_LOGMNR_INTERNAL - show dependent code
Package BodyDBMS_PICKLER - show dependent code
Package BodyDBMS_REPCAT_UTL4 - show dependent code
ViewKU$_ALL_TSLTZ_TAB_COLS
ViewKU$_TYPE_ATTR_VIEW
ViewUSER_PLSQL_TYPE_ATTRS
ViewUSER_SQLJ_TYPE_ATTRS
ViewUSER_TRIGGER_COLS
ViewUSER_TSTZ_TAB_COLS
ViewUSER_TYPE_ATTRS