[Home] [Help] [Dependency Information]
Object Name: | OPT_DIRECTIVE$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 1 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_OPT_DIRECTIVE_DIRID | NORMAL | UNIQUE | SYSAUX | DIR_ID |
SYS_IL0000624320C00016$$ | LOB | UNIQUE | SYSAUX | |
I_OPT_DIRECTIVE_DIROWN# | NORMAL | NONUNIQUE | SYSAUX | DIR_OWN# |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIR_OWN# | NUMBER | Yes | ||
DIR_ID | NUMBER | Yes | ||
F_ID | NUMBER | Yes | ||
TYPE | NUMBER | Yes | ||
STATE | NUMBER | Yes | ||
FLAGS | NUMBER | Yes | ||
CREATED | DATE | Yes | ||
LAST_MODIFIED | DATE | |||
LAST_USED | DATE | |||
NUM_ONE | NUMBER | |||
NUM_TWO | NUMBER | |||
NUM_THREE | NUMBER | |||
VC_ONE | VARCHAR2 | (4000) | ||
VC_TWO | VARCHAR2 | (4000) | ||
VC_THREE | VARCHAR2 | (4000) | ||
CL_ONE | CLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT DIR_OWN#
, DIR_ID
, F_ID
, TYPE
, STATE
, FLAGS
, CREATED
, LAST_MODIFIED
, LAST_USED
, NUM_ONE
, NUM_TWO
, NUM_THREE
, VC_ONE
, VC_TWO
, VC_THREE
, CL_ONE
FROM SYS.OPT_DIRECTIVE$;
SYS.OPT_DIRECTIVE$ does not reference any database object
SYS.OPT_DIRECTIVE$ is referenced by following:
|
|
|