[Home] [Help] [Dependency Information]
Object Name: | DR$INDEX_PARTITION |
---|---|
Object Type: | TABLE |
Owner: | CTXSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | CTXD |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
DRC$IXP_KEY | NORMAL | UNIQUE | CTXD |
IXP_IDX_ID
IXP_ID |
DRX$IXP_NAME | NORMAL | UNIQUE | CTXD |
IXP_IDX_ID
IXP_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IXP_ID | NUMBER | (38) | Yes | |
IXP_NAME | VARCHAR2 | (30) | Yes | |
IXP_IDX_ID | NUMBER | (38) | Yes | |
IXP_TABLE_PARTITION# | NUMBER | (38) | Yes | |
IXP_DOCID_COUNT | NUMBER | (38) | ||
IXP_STATUS | VARCHAR2 | (12) | Yes | |
IXP_NEXTID | NUMBER | (38) | ||
IXP_OPT_TOKEN | VARCHAR2 | (64) | ||
IXP_OPT_TYPE | NUMBER | (38) | ||
IXP_OPT_COUNT | NUMBER | (38) | ||
IXP_SYNC_TYPE | VARCHAR2 | (20) | ||
IXP_SYNC_MEMORY | VARCHAR2 | (100) | ||
IXP_SYNC_PARA_DEGREE | NUMBER | |||
IXP_SYNC_INTERVAL | VARCHAR2 | (2000) | ||
IXP_SYNC_JOBNAME | VARCHAR2 | (50) | ||
IXP_OPTION | VARCHAR2 | (40) |
Cut, paste (and edit) the following text to query this object:
SELECT IXP_ID
, IXP_NAME
, IXP_IDX_ID
, IXP_TABLE_PARTITION#
, IXP_DOCID_COUNT
, IXP_STATUS
, IXP_NEXTID
, IXP_OPT_TOKEN
, IXP_OPT_TYPE
, IXP_OPT_COUNT
, IXP_SYNC_TYPE
, IXP_SYNC_MEMORY
, IXP_SYNC_PARA_DEGREE
, IXP_SYNC_INTERVAL
, IXP_SYNC_JOBNAME
, IXP_OPTION
FROM CTXSYS.DR$INDEX_PARTITION;
CTXSYS.DR$INDEX_PARTITION does not reference any database object
CTXSYS.DR$INDEX_PARTITION is referenced by following:
|
|
|