SAP Table ORA_TABLESPACES

Oracle monitor: Copy of DBA_TABLESPACES

ORA_TABLESPACES (Oracle monitor: Copy of DBA_TABLESPACES) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ORA_TABLESPACES to other SAP tables.

ORA_TABLESPACES table fields

Field Data element Checktable Datatype Length Decimals
SNAPSHOT_ID Oracle monitor: snapshot ID ORA_SNAPSHOT_ID NUMC 10 0
TABLESPACE_NAME Oracle monitoring: Name ORA_NAME CHAR 64 0
BLOCK_SIZE Oracle monitor: BLOCK SIZE ORA_BLOCK_SIZE DEC 22 0
INITIAL_EXTENT Oracle monitor: Initial extent ORA_INITIAL_EXT DEC 22 0
NEXT_EXTENT Oracle monitor: Next extent ORA_NEXT_EXTENT DEC 22 0
MIN_EXTENTS Oracle monitor: Minimum extent ORA_MIN_EXTENTS DEC 22 0
MAX_EXTENTS Oracle monitor: Maximum extent ORA_MAX_EXTENTS DEC 22 0
PCT_INCREASE Oracle monitor. PCT increase ORA_PCT_INCREASE DEC 22 0
MIN_EXTLEN Oracle monitor: Minimum extent legth ORA_MIN_EXTLEN DEC 22 0
STATUS Oracle monitoring: Current process status ORA_STATUS CHAR 12 0
CONTENTS Oracle monitor: Contents ORA_CONTENTS CHAR 12 0
LOGGING Oracle monitor: Loggins ORA_LOGGING CHAR 12 0
FORCE_LOGGING Oracle monitoring: db force logging ORA_FORCE_LOGGING CHAR 3 0
EXTENT_MANAGEMEN Oracle monitor: Extent management ORA_EXTENT_MANAGEMENT CHAR 12 0
ALLOCATION_TYPE Oracle monitor: allocation type ORA_ALLOCATION_TYPE CHAR 12 0
PLUGGED_IN Oracle monitor: Plugged in ORA_PLUGGED_IN_I CHAR 3 0
SEGMENT_SPACE_MA Oracle monitor: Segment space management ORA_SEGMENT_SPACE_MANAGEMENT CHAR 6 0
DEF_TAB_COMPRESS Oracle monitor: Segment space management ORA_DEF_TAB_COMPRESSION CHAR 8 0