SAP Table TAB_ORA
ORACLE Table Information from dba_tables
TAB_ORA (ORACLE Table Information from dba_tables) 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 TAB_ORA to other SAP tables.
TAB_ORA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| OWNER | Table owner | TAB_OWNER | CHAR | 30 | 0 | |||
| TABLE_NAME | Table Name | TABLE_NAME | CHAR | 30 | 0 | |||
| TSP_NAME | Tablespace name | TSP_NAME | CHAR | 30 | 0 | |||
| CLUST_NAME | Cluster name | CLUST_NAME | CHAR | 30 | 0 | |||
| PCT_FREE | Pct free | PCT_FREE | DEC | 17 | 0 | |||
| PCT_USED | % used | PCT_USED | DEC | 17 | 0 | |||
| INI_TRANS | Ini trans | INI_TRANS | DEC | 17 | 0 | |||
| MAX_TRANS | Max trans | MAX_TRANS | DEC | 17 | 0 | |||
| INI_EXT | Initial extent | SEG_INIT | DEC | 17 | 0 | |||
| NEXT_EXT | Next extent | SEG_NEXT | DEC | 17 | 0 | |||
| MINEXTS | Min extents | SEG_MINEXT | DEC | 17 | 0 | |||
| MAXEXTS | Max extents | SEG_MAXEXT | DEC | 17 | 0 | |||
| PCT_INC | Pct inc | SEG_PCTINC | DEC | 17 | 0 | |||
| BACKED_UP | Backed up | BACKED_UP | CHAR | 1 | 0 | |||
| NUM_ROWS | Number of rows | NUMROWS | DEC | 17 | 0 | |||
| BLOCKS | Blocks used | BLKS | DEC | 17 | 0 | |||
| EMPTY_BLKS | Empty blocks | EMPTY_BLKS | DEC | 17 | 0 | |||
| AVG_SPACE | Average space | AVG_SPACE | DEC | 17 | 0 | |||
| CHAIN_CNT | Chain count | CHAIN_CNT | DEC | 17 | 0 | |||
| AVG_ROW_LN | Average row length | AVG_ROW_LN | DEC | 17 | 0 | |||
| DEGREE | Degree | DEGREE | CHAR | 10 | 0 | |||
| INSTANCES | Instances | INSTANCES0 | CHAR | 10 | 0 | |||
| CACHE | Cache | CACHE | CHAR | 5 | 0 | |||
