SAP ORA_DBA_OBJECTS table - Copy of DBA_OBJECTS (currently not provided with snapshots) details in SAP


SAP ORA_DBA_OBJECTS table summary

Object Name: ORA_DBA_OBJECTS
Dictionary Type: Transparent table
Description: Copy of DBA_OBJECTS (currently not provided with snapshots)


Field list for ORA_DBA_OBJECTS table on an S/4 SAP system

Details
ORA_DBA_OBJECTS-SNAPSHOT_ID table field - Oracle monitor: snapshot ID

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

ORA_DBA_OBJECTS-OWNER table field - Oracle monitoring: Owner of the object

Description: Oracle monitoring: Owner of the object
Field Name: OWNER
Data Element: ORA_OWNER_30
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNER

ORA_DBA_OBJECTS-OBJECT_NAME table field - Oracle monitoring: Objects name

Description: Oracle monitoring: Objects name
Field Name: OBJECT_NAME
Data Element: ORA_OBJECT_NAME_2
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_128
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_NAME

ORA_DBA_OBJECTS-SUBOBJECT_NAME table field - Oracle monitoring: subobject name

Description: Oracle monitoring: subobject name
Field Name: SUBOBJECT_NAME
Data Element: ORA_SUBOBJECT_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUBOBJECT_NAME

ORA_DBA_OBJECTS-OBJECT_ID table field - Oracle monitoring: Dictionary object number of the object

Description: Oracle monitoring: Dictionary object number of the object
Field Name: OBJECT_ID
Data Element: ORA_OBJECT_ID_2
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_ID

ORA_DBA_OBJECTS-DATA_OBJECT_ID table field - Oracle monitoring: Dictionary obj. nr. of segment wh. ct.obj

Description: Oracle monitoring: Dictionary obj. nr. of segment wh. ct.obj
Field Name: DATA_OBJECT_ID
Data Element: ORA_DATA_OBJECT_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATA_OBJECT_ID

ORA_DBA_OBJECTS-OBJECT_TYPE table field - Oracle monitoring: Type of the object

Description: Oracle monitoring: Type of the object
Field Name: OBJECT_TYPE
Data Element: ORA_OBJECT_TYPE
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_18
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_TYPE

ORA_DBA_OBJECTS-CREATED_D table field - Oracle monitoring: Object creation date

Description: Oracle monitoring: Object creation date
Field Name: CREATED_D
Data Element: ORA_CREATED_D
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_D

ORA_DBA_OBJECTS-CREATED_T table field - Oracle monitoring: Object creation time

Description: Oracle monitoring: Object creation time
Field Name: CREATED_T
Data Element: ORA_CREATED_T
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: ORA_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_T

ORA_DBA_OBJECTS-LAST_DDL_TIME_D table field - Oracle monitoring: last DDL statement on object (date)

Description: Oracle monitoring: last DDL statement on object (date)
Field Name: LAST_DDL_TIME_D
Data Element: ORA_LAST_DDL_TIME_D
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_DDL_TIME_D

ORA_DBA_OBJECTS-LAST_DDL_TIME_T table field - Oracle monitoring: last DDL statement on object (time)

Description: Oracle monitoring: last DDL statement on object (time)
Field Name: LAST_DDL_TIME_T
Data Element: ORA_LAST_DDL_TIME_T
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: ORA_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_DDL_TIME_T

ORA_DBA_OBJECTS-TIMESTAMP table field - Oracle monitoring: Timestamp for the spec. of the object

Description: Oracle monitoring: Timestamp for the spec. of the object
Field Name: TIMESTAMP
Data Element: ORA_TIMESTAMP_2
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMESTAMP

ORA_DBA_OBJECTS-STATUS table field - Oracle monitoring: Status of object

Description: Oracle monitoring: Status of object
Field Name: STATUS
Data Element: ORA_STATUS_2
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_7
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

ORA_DBA_OBJECTS-TEMPORARY_OBJ table field - Oracle monitoring: Whether the object is temporary

Description: Oracle monitoring: Whether the object is temporary
Field Name: TEMPORARY_OBJ
Data Element: ORA_TEMPORARY_2
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEMPORARY_OBJ

ORA_DBA_OBJECTS-GENERATED table field - Oracle monitoring: Was name of this object system generated

Description: Oracle monitoring: Was name of this object system generated
Field Name: GENERATED
Data Element: ORA_GENERATED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GENERATED

ORA_DBA_OBJECTS-SECONDARY table field - Oracle monitoring: Is trigger a secondary object

Description: Oracle monitoring: Is trigger a secondary object
Field Name: SECONDARY
Data Element: ORA_SECONDARY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SECONDARY


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table