[Home] [Help] [Dependency Information]
Object Name: | INDEX_ORPHANED_ENTRY_V$ |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDEX_OWNER | VARCHAR2 | (128) | Yes | |
INDEX_NAME | VARCHAR2 | (128) | Yes | |
INDEX_SUBNAME | VARCHAR2 | (128) | ||
INDEX_OBJECT_ID | NUMBER | Yes | ||
TABLE_OWNER | VARCHAR2 | (128) | Yes | |
TABLE_NAME | VARCHAR2 | (128) | Yes | |
TABLE_SUBNAME | VARCHAR2 | (128) | ||
TABLE_OBJECT_ID | NUMBER | Yes | ||
TYPE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT INDEX_OWNER
, INDEX_NAME
, INDEX_SUBNAME
, INDEX_OBJECT_ID
, TABLE_OWNER
, TABLE_NAME
, TABLE_SUBNAME
, TABLE_OBJECT_ID
, TYPE
FROM SYS.INDEX_ORPHANED_ENTRY_V$;
|
|
|