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

TABLE: SYS.SQLOBJ$DATA

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

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SQLOBJ$DATA_PKEY
  1. ColumnSIGNATURE
  2. ColumnCATEGORY
  3. ColumnOBJ_TYPE
  4. ColumnPLAN_ID
Indexes
Index Type Uniqueness Tablespace Column
SQLOBJ$DATA_PKEY IOT - TOP UNIQUE TablespaceSYSAUX ColumnSIGNATURE
ColumnCATEGORY
ColumnOBJ_TYPE
ColumnPLAN_ID
SYS_IL0000468299C00005$$ LOB UNIQUE TablespaceSYSAUX
SYS_IL0000468299C00007$$ LOB UNIQUE TablespaceSYSAUX
Columns
Name Datatype Length Mandatory Comments
SIGNATURE NUMBER
Yes
CATEGORY VARCHAR2 (128) Yes
OBJ_TYPE NUMBER
Yes
PLAN_ID NUMBER
Yes
COMP_DATA CLOB (644) Yes
SPARE1 NUMBER

SPARE2 CLOB (644)
Query Text

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


SELECT SIGNATURE
,      CATEGORY
,      OBJ_TYPE
,      PLAN_ID
,      COMP_DATA
,      SPARE1
,      SPARE2
FROM SYS.SQLOBJ$DATA;

Dependencies

[top of page]

SYS.SQLOBJ$DATA does not reference any database object

SYS.SQLOBJ$DATA is referenced by following:

SchemaSYS
ViewDBMSHSXP_SQL_PROFILE_ATTR