[Home] [Help] [Dependency Information]
Object Name: | CTX_USER_INDEX_PARTITIONS |
---|---|
Object Type: | VIEW |
Owner: | CTXSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IXP_ID | NUMBER | (38) | Yes | |
IXP_INDEX_NAME | VARCHAR2 | (30) | Yes | |
IXP_INDEX_PARTITION_NAME | VARCHAR2 | (30) | Yes | |
IXP_TABLE_OWNER | VARCHAR2 | (128) | Yes | |
IXP_TABLE_NAME | VARCHAR2 | (128) | Yes | |
IXP_TABLE_PARTITION_NAME | VARCHAR2 | (128) | ||
IXP_DOCID_COUNT | NUMBER | (38) | ||
IXP_STATUS | VARCHAR2 | (12) | Yes | |
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) |
Cut, paste (and edit) the following text to query this object:
SELECT IXP_ID
, IXP_INDEX_NAME
, IXP_INDEX_PARTITION_NAME
, IXP_TABLE_OWNER
, IXP_TABLE_NAME
, IXP_TABLE_PARTITION_NAME
, IXP_DOCID_COUNT
, IXP_STATUS
, IXP_SYNC_TYPE
, IXP_SYNC_MEMORY
, IXP_SYNC_PARA_DEGREE
, IXP_SYNC_INTERVAL
, IXP_SYNC_JOBNAME
FROM CTXSYS.CTX_USER_INDEX_PARTITIONS;
|
|
|