ORA_DBA_OBJECTS - Copy of DBA_OBJECTS (currently not provided with snapshots)

Copy of DBA_OBJECTS (currently not provided with snapshots) information is stored in SAP table ORA_DBA_OBJECTS.
 It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".

Fields for table ORA_DBA_OBJECTS

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SNAPSHOT_IDOracle monitor: snapshot IDXORA_SNAPSHOT_IDNUMC10*
OWNEROracle monitoring: Owner of the objectXORA_OWNER_30CHAR30
OBJECT_NAMEOracle monitoring: Objects nameXORA_OBJECT_NAME_2CHAR128
SUBOBJECT_NAMEOracle monitoring: subobject nameXORA_SUBOBJECT_NAMECHAR30
OBJECT_IDOracle monitoring: Dictionary object number of the objectXORA_OBJECT_ID_2DEC12
DATA_OBJECT_IDOracle monitoring: Dictionary obj. nr. of segment wh. ct.objORA_DATA_OBJECT_IDDEC12
OBJECT_TYPEOracle monitoring: Type of the objectORA_OBJECT_TYPECHAR18
CREATED_DOracle monitoring: Object creation dateORA_CREATED_DDATS8
CREATED_TOracle monitoring: Object creation timeORA_CREATED_TTIMS6
LAST_DDL_TIME_DOracle monitoring: last DDL statement on object (date)ORA_LAST_DDL_TIME_DDATS8
LAST_DDL_TIME_TOracle monitoring: last DDL statement on object (time)ORA_LAST_DDL_TIME_TTIMS6
TIMESTAMPOracle monitoring: Timestamp for the spec. of the objectORA_TIMESTAMP_2CHAR20
STATUSOracle monitoring: Status of objectORA_STATUS_2CHAR7
TEMPORARY_OBJOracle monitoring: Whether the object is temporaryORA_TEMPORARY_2CHAR1
GENERATEDOracle monitoring: Was name of this object system generatedORA_GENERATEDCHAR1
SECONDARYOracle monitoring: Is trigger a secondary objectORA_SECONDARYCHAR1
Privacy Policy