SAP /SDF/ORATABINF2 table - Oracle table information details in SAP
SAP /SDF/ORATABINF2 table summary
Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101Object Name: /SDF/ORATABINF2
Dictionary Type: Structure
Description: Oracle table information
Field list for /SDF/ORATABINF2 table on an S/4 SAP system
Details |
/SDF/ORATABINF2-ANALY_ID table field - Analysis ID ▼Description: Analysis ID |
/SDF/ORATABINF2-STMT_ID table field - Statement ID ▼Description: Statement ID |
/SDF/ORATABINF2-TABLE_OWNER table field - Table owner ▼Description: Table owner |
/SDF/ORATABINF2-TABLE_NAME table field - Table Name ▼Description: Table Name |
/SDF/ORATABINF2-NUM_ROWS table field - Number of Rows ▼Description: Number of Rows |
/SDF/ORATABINF2-BLOCKS table field - Blocks used ▼Description: Blocks used |
/SDF/ORATABINF2-EMPTY_BLKS table field - Empty Blocks ▼Description: Empty Blocks |
/SDF/ORATABINF2-AVG_SPACE table field - Average Space ▼Description: Average Space |
/SDF/ORATABINF2-CHAIN_CNT table field - Chain Count ▼Description: Chain Count |
/SDF/ORATABINF2-AVG_ROW_LN table field - Average row length ▼Description: Average row length |
/SDF/ORATABINF2-SAMPL_SIZE table field - Sample Size ▼Description: Sample Size |
/SDF/ORATABINF2-LAST_ANALY table field - Last Update Statistic ▼Description: Last Update Statistic |
/SDF/ORATABINF2-LAST_CHANG table field - Last change in SAP DDIC ▼Description: Last change in SAP DDIC |
/SDF/ORATABINF2-BUFF_TYPE table field - Type of buffering of Table ▼Description: Type of buffering of Table |
/SDF/ORATABINF2-TABLESPACE_NAME table field - Name of the tablespace ▼Description: Name of the tablespace |
/SDF/ORATABINF2-IOT_NAME table field - Name of the indexed table ▼Description: Name of the indexed table |
/SDF/ORATABINF2-STATUS table field - If a previous DROP TABLE operation failed (valid or UNUSABLE ▼Description: If a previous DROP TABLE operation failed (valid or UNUSABLE |
/SDF/ORATABINF2-PCT_FREE table field - Minimum Percentage of Free Space in a Block ▼Description: Minimum Percentage of Free Space in a Block |
/SDF/ORATABINF2-LOGGING table field - Indicates whether changes to the table are logged ▼Description: Indicates whether changes to the table are logged |
/SDF/ORATABINF2-BACKED_UP table field - Indicates whether the table has been backed up since the las ▼Description: Indicates whether the table has been backed up since the las |
/SDF/ORATABINF2-AVG_SP_FREL_BLK table field - Average free space of all blocks on a free list ▼Description: Average free space of all blocks on a free list |
/SDF/ORATABINF2-NUM_FREL_BLCKS table field - Number of blocks on the free list ▼Description: Number of blocks on the free list |
/SDF/ORATABINF2-DEGREE table field - Number of threads per instance for scanning the table, or DE ▼Description: Number of threads per instance for scanning the table, or DE |
/SDF/ORATABINF2-INSTANCES table field - Number of instances across which the table is to be scanned, ▼Description: Number of instances across which the table is to be scanned, |
/SDF/ORATABINF2-CACHE table field - Indicates whether the table is partitioned (YES/NO) ▼Description: Indicates whether the table is partitioned (YES/NO) |
/SDF/ORATABINF2-TABLE_LOCK table field - Indicates whether table locking is enabled (ENABLED) ▼Description: Indicates whether table locking is enabled (ENABLED) |
/SDF/ORATABINF2-PARTITIONED table field - Indicates whether the table is partitioned (YES/NO) ▼Description: Indicates whether the table is partitioned (YES/NO) |
/SDF/ORATABINF2-IOT_TYPE table field - If the table is indexed ▼Description: If the table is indexed |
/SDF/ORATABINF2-BUFFER_POOL table field - Default buffer pool for the table ▼Description: Default buffer pool for the table |
/SDF/ORATABINF2-ROW_MOVEMENT table field - Indicates whether partitioned row movement is enabled ▼Description: Indicates whether partitioned row movement is enabled |
/SDF/ORATABINF2-GLOBAL_STATS table field - Partitioned tables (statistics were collected as a whole ) ▼Description: Partitioned tables (statistics were collected as a whole ) |
/SDF/ORATABINF2-USER_STATS table field - Entered directly by the user ▼Description: Entered directly by the user |
/SDF/ORATABINF2-TEMPORARY table field - Indicates whether the table is temporary (Y or N) ▼Description: Indicates whether the table is temporary (Y or N) |
/SDF/ORATABINF2-DURATION table field - Duration of a temporary table (session or transaction) ▼Description: Duration of a temporary table (session or transaction) |
/SDF/ORATABINF2-SKIP_CORRUPT table field - Indicates whether Oracle Database ignores blocks marked corr ▼Description: Indicates whether Oracle Database ignores blocks marked corr |
/SDF/ORATABINF2-DEPENDENCIES table field - Indicates whether row-level dependency tracking is enabled ▼Description: Indicates whether row-level dependency tracking is enabled |
/SDF/ORATABINF2-COMPRESSION table field - Indicates whether table compression is enabled (ENABLED) ▼Description: Indicates whether table compression is enabled (ENABLED) |
/SDF/ORATABINF2-COMPRESS_FOR table field - Default compression for what kind of operations ▼Description: Default compression for what kind of operations |
/SDF/ORATABINF2-DROPPED table field - Indicates whether the table has been dropped and is in the r ▼Description: Indicates whether the table has been dropped and is in the r |
/SDF/ORATABINF2-CREATED table field - Timestamp for Creation of Object ▼Description: Timestamp for Creation of Object |
/SDF/ORATABINF2-LAST_DDL_TIME table field - Timestamp for Last Modification from a DDL Command ▼Description: Timestamp for Last Modification from a DDL Command |
/SDF/ORATABINF2-FLASH_CACHE table field - Database Smart Flash Cache hint for table blocks ▼Description: Database Smart Flash Cache hint for table blocks |
/SDF/ORATABINF2-CELL_F_CACHE table field - Cell flash cache hint for table blocks ▼Description: Cell flash cache hint for table blocks |
/SDF/ORATABINF2-SEGMENT_CREATED table field - table segment is created (Yes or No) ▼Description: table segment is created (Yes or No) |
/SDF/ORATABINF2-READ_ONLY table field - table IS READ-ONLY (YES) or not (NO) ▼Description: table IS READ-ONLY (YES) or not (NO) |
/SDF/ORATABINF2-ACT_TRACKING table field - Indicates whether Heat Map tracking is enabled on the table ▼Description: Indicates whether Heat Map tracking is enabled on the table |
/SDF/ORATABINF2-DML_TIMESTAMP table field - Modification time, creation time or both, for Automatic Data ▼Description: Modification time, creation time or both, for Automatic Data |
/SDF/ORATABINF2-HAS_IDENTITY table field - Indicates whether the table has an identity column: Y or N ▼Description: Indicates whether the table has an identity column: Y or N |
/SDF/ORATABINF2-CONTAINER_DATA table field - Table contains container-specific data: yes or no ▼Description: Table contains container-specific data: yes or no |
/SDF/ORATABINF2-INMEMORY table field - Indicates whether the In-Memory Column Store (IM column stor ▼Description: Indicates whether the In-Memory Column Store (IM column stor |
/SDF/ORATABINF2-INMEMORY_PRIO table field - Indicates the priority for In-Memory Column Store (IM column ▼Description: Indicates the priority for In-Memory Column Store (IM column |
/SDF/ORATABINF2-INMEMORY_DISTR table field - Indicates how the IM column store is distributed in RAC ▼Description: Indicates how the IM column store is distributed in RAC |
/SDF/ORATABINF2-INMEMORY_COMPR table field - Indicates the compression level for the IM column store ▼Description: Indicates the compression level for the IM column store |
/SDF/ORATABINF2-INMEMORY_DUPL table field - Duplicate setting for the IM column for Oracle RAC ▼Description: Duplicate setting for the IM column for Oracle RAC |
/SDF/ORATABINF2-STMT_SOURCE table field - DBA HIST (D) or cache (C) ▼Description: DBA HIST (D) or cache (C) |
/SDF/ORATABINF2-DBA_HIST_B_TS table field - Start of time stamp for statement selection from DBA HIST ▼Description: Start of time stamp for statement selection from DBA HIST |
/SDF/ORATABINF2-DBA_HIST_E_TS table field - End of time stamp for statement selection from DBA HIST ▼Description: End of time stamp for statement selection from DBA HIST |
Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279
View list of all SAP tables(S4H/ECC)
Select data from SAP table