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


TABLE: SYS.EDITION$

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0001098209C00004$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
P_OBJ# NUMBER

FLAGS NUMBER

CODE BLOB (4000)
AUDIT$ VARCHAR2 (38) Yes
SPARE1 NUMBER

SPARE2 VARCHAR2 (128)
Query Text

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


SELECT OBJ#
,      P_OBJ#
,      FLAGS
,      CODE
,      AUDIT$
,      SPARE1
,      SPARE2
FROM SYS.EDITION$;

Dependencies

[top of page]

SYS.EDITION$ does not reference any database object

SYS.EDITION$ is referenced by following:

SchemaSYS
ViewALL_EDITIONS
ViewDBA_EDITIONS
ViewDBA_OBJ_AUDIT_OPTS
ViewUSABLE_EDITIONS
ViewUSER_OBJ_AUDIT_OPTS