[Home] [Help] [Dependency Information]
Object Name: | OPTSTAT_USER_PREFS$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_USER_PREFS$ | NORMAL | UNIQUE | SYSTEM |
OBJ#
PNAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | |||
PNAME | VARCHAR2 | (30) | ||
VALNUM | NUMBER | |||
VALCHAR | VARCHAR2 | (4000) | ||
CHGTIME | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
SPARE1 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, PNAME
, VALNUM
, VALCHAR
, CHGTIME
, SPARE1
FROM SYS.OPTSTAT_USER_PREFS$;
SYS.OPTSTAT_USER_PREFS$ does not reference any database object
SYS.OPTSTAT_USER_PREFS$ is referenced by following:
|
|
|