1. Home
  2. Resources
  3. SAP Tables
  4. ORAIS - Table Parameters for ORACLE, Version 8

SAP Table ORAIS

Table Parameters for ORACLE, Version 8

ORAIS (Table Parameters for ORACLE, Version 8) 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 ORAIS to other SAP tables.

ORAIS table fields

Field Data element Checktable Datatype Length Decimals
TABSPACE Tablespace Name for ORACLE ORATSPNAME TSORA CHAR 30 0
INIT Size of an initial ORACLE extent in KB ORAINIT NUMC 10 0
NEXT Size of an ORACLE next extent in KB ORANEXT NUMC 10 0
MINEXT Minimum number of ORACLE extents ORAMINEXT NUMC 10 0
0000000001 Value range of the extent
0000000501 Enhanced Value Range for Extents
MAXEXT Maximum number of ORACLE extents ORAMAXEXT NUMC 10 0
0000000001 Value range of the extent
0000000501 Enhanced Value Range for Extents
PCTINC PCTincrease - parameters PCTINC NUMC 4 0
OFREELIST DD: Number of free storage lists per group OFREELISTS NUMC 3 0
OFREEGROUP DD: Number of groups of free lists OFREEGROUP NUMC 2 0
OPCTFREE DD: Reserved storage area for updates OPCTFREE NUMC 2 0
00 Percentage
OPCTUSED DD: Lower limit for assignment of data blocks OPCTUSED NUMC 2 0
00 Percentage
INITRANS NUMC 3 0
INDEXORG Flag if table has structure INDEX ORGANISATION INDEXORG CHAR 1 0
NULL FALSE
X TRUE
BITMAP Index ist created as BITMAP BITMAP CHAR 1 0
NULL Index organized as B tree
X Index organized as BITMAP
LOCALITY Locality category LOCALITY CHAR 5 0
DEFAULT Database default DBSSTORDEF CHAR 1 0
INDCOMPR_CLAUSE Oracle Index Compression Definition (as of Oracle 11) ORAINDCOMPRESS CHAR 20 0

ORAIS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ORAIS TABSPACE ORAIS TABSPACE TSORA Table of valid ORACLE tablespaces TABSPACE