[Home] [Help] [Dependency Information]
Object Name: | DBA_INVALID_OBJECTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
OBJECT_NAME | VARCHAR2 | (128) | ||
SUBOBJECT_NAME | VARCHAR2 | (128) | ||
OBJECT_ID | NUMBER | |||
DATA_OBJECT_ID | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (23) | ||
CREATED | DATE | |||
LAST_DDL_TIME | DATE | |||
TIMESTAMP | VARCHAR2 | (19) | ||
STATUS | VARCHAR2 | (7) | ||
TEMPORARY | VARCHAR2 | (1) | ||
GENERATED | VARCHAR2 | (1) | ||
SECONDARY | VARCHAR2 | (1) | ||
NAMESPACE | NUMBER | |||
EDITION_NAME | VARCHAR2 | (128) | ||
SHARING | VARCHAR2 | (13) | ||
EDITIONABLE | VARCHAR2 | (1) | ||
ORACLE_MAINTAINED | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, OBJECT_NAME
, SUBOBJECT_NAME
, OBJECT_ID
, DATA_OBJECT_ID
, OBJECT_TYPE
, CREATED
, LAST_DDL_TIME
, TIMESTAMP
, STATUS
, TEMPORARY
, GENERATED
, SECONDARY
, NAMESPACE
, EDITION_NAME
, SHARING
, EDITIONABLE
, ORACLE_MAINTAINED
FROM SYS.DBA_INVALID_OBJECTS;
|
|
|