SYS.ALL_OBJECTS

The ALL_OBJECTS view describes all objects in the database that are accessible to the current user.

Related views

• SYS.DBA_OBJECTS describes all objects in the database. It has the same columns as ALL_OBJECTS.

• SYS.USER_OBJECTS describes all objects owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Object owner
OBJECT_NAME	VARCHAR2(30) INLINE	Object name
SUBOBJECT_NAME	VARCHAR2(30) INLINE	Unused (Column unused by TimesTen. Ignore value.)
OBJECT_ID	TT_BIGINT NOT NULL	Dictionary object number of the object
DATA_OBJECT_ID	TT_BIGINT	Unused (Column unused by TimesTen. Ignore value.)
OBJECT_TYPE	VARCHAR2(17) INLINE NOT NULL	Object type (such as PROCEDURE, FUNCTION)
CREATED	DATE NOT NULL	Timestamp for creation of object
LAST_DDL_TIME	DATE NOT NULL	Timestamp for the last modification of the object resulting from a DDL statement
TIMESTAMP	VARCHAR2(78) INLINE NOT NULL	Timestamp for the specification of the object (character data)
STATUS	VARCHAR2(7) INLINE NOT NULL	Status of the object (VALID, INVALID, or N/A)
TEMPORARY	VARCHAR2(1) INLINE NOT NULL	Y for temporary object; N otherwise The current session can see only data that it placed in this object itself. The value is always 'Y'.
GENERATED	VARCHAR2(1) INLINE NOT NULL	Y for system-generated object; N otherwise The value is always 'N'.
SECONDARY	VARCHAR2(1) INLINE NOT NULL	Y if there is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge; N otherwise The value is always 'N'.
NAMESPACE	TT_INTEGER NOT NULL	Namespace for the object
EDITION_NAME	VARCHAR2(30) INLINE	Unused (Column unused by TimesTen. Ignore value.)