SAP ABAP Table ORATS (Table Parameters for ORACLE, Version 8)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD
     ⤷ SDIC (Package) ABAP Dictionary

Basic Data

Table Category	INTTAB	Structure
Structure	ORATS	Table Relationship Diagram
Short Description	Table Parameters for ORACLE, Version 8

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TABSPACE	☐	ORATSPNAME	ORATSPNAME	CHAR	30	0	Tablespace Name	TSORA
2	INIT	☐	ORAINIT	ORAEXT	NUMC	10	0	Size of an initial ORACLE extent in KB
3	NEXT	☐	ORANEXT	ORAEXT	NUMC	10	0	Size of an ORACLE next extent in KB
4	MINEXT	☐	ORAMINEXT	ORAEXTNUM	NUMC	10	0	Minimum number of ORACLE extents
5	MAXEXT	☐	ORAMAXEXT	ORAEXTNUM	NUMC	10	0	Maximum number of ORACLE extents
6	PCTINC	☐	PCTINC	PCTINC	NUMC	4	0	PCTincrease - parameters
7	OFREELIST	☐	OFREELISTS	OFREELISTS	NUMC	3	0	DD: Number of free storage lists per group
8	OFREEGROUP	☐	OFREEGROUP	OFREEGROUP	NUMC	2	0	DD: Number of groups of free lists
9	OPCTFREE	☐	OPCTFREE	OPCTFREE	NUMC	2	0	DD: Reserved storage area for updates
10	OPCTUSED	☐	OPCTUSED	OPCTUSED	NUMC	2	0	DD: Lower limit for assignment of data blocks
11	INITRANS	☐			NUMC	3	0
12	INDEXORG	☐	INDEXORG	DDBOOL	CHAR	1	0	Flag if table has structure INDEX ORGANISATION
13	PARTBY	☐	PARTBY	PARTBY	CHAR	12	0	Partition category
14	SUBPARTBY	☐	SUBPARTBY	SUBPARTBY	CHAR	12	0	Subpartitioning (Oracle 10)
15	DEFAULT	☐	DBSSTORDEF	DBSSTORDEF	CHAR	1	0	Database default
16	COMPR_CLAUSE	☐	ORACOMPRESS		CHAR	40	0	Oracle Compression Definition (as of Oracle 11)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ORATS	TABSPACE	TSORA	TABSPACE	REF	1	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in