SAP ABAP Table TAB_ORA (ORACLE Table Information from dba_tables)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
     ⤷ SDBO (Package) Database Administration: Oracle-Specific Components

Basic Data

Table Category	INTTAB	Structure
Structure	TAB_ORA	Table Relationship Diagram
Short Description	ORACLE Table Information from dba_tables

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	OWNER	☑	TAB_OWNER	CHAR30	CHAR	30	0	Table owner
2	TABLE_NAME	☑	TABLE_NAME	CHAR30	CHAR	30	0	Table Name
3	TSP_NAME	☐	TSP_NAME	CHAR_30	CHAR	30	0	Tablespace name
4	CLUST_NAME	☐	CLUST_NAME	CHAR30	CHAR	30	0	Cluster name
5	PCT_FREE	☐	PCT_FREE	DEC17	DEC	17	0	Pct free
6	PCT_USED	☐	PCT_USED	DEC17	DEC	17	0	% used
7	INI_TRANS	☐	INI_TRANS	DEC17	DEC	17	0	Ini trans
8	MAX_TRANS	☐	MAX_TRANS	DEC17	DEC	17	0	Max trans
9	INI_EXT	☐	SEG_INIT	DEC17	DEC	17	0	Initial extent
10	NEXT_EXT	☐	SEG_NEXT	DEC17	DEC	17	0	Next extent
11	MINEXTS	☐	SEG_MINEXT	DEC17	DEC	17	0	Min extents
12	MAXEXTS	☐	SEG_MAXEXT	DEC17	DEC	17	0	Max extents
13	PCT_INC	☐	SEG_PCTINC	DEC17	DEC	17	0	Pct inc
14	BACKED_UP	☐	BACKED_UP	CHAR1	CHAR	1	0	Backed up
15	NUM_ROWS	☐	NUMROWS	DEC17	DEC	17	0	Number of rows
16	BLOCKS	☐	BLKS	DEC17	DEC	17	0	Blocks used
17	EMPTY_BLKS	☐	EMPTY_BLKS	DEC17	DEC	17	0	Empty blocks
18	AVG_SPACE	☐	AVG_SPACE	DEC17	DEC	17	0	Average space
19	CHAIN_CNT	☐	CHAIN_CNT	DEC17	DEC	17	0	Chain count
20	AVG_ROW_LN	☐	AVG_ROW_LN	DEC17	DEC	17	0	Average row length
21	DEGREE	☐	DEGREE	CHAR10	CHAR	10	0	Degree
22	INSTANCES	☐	INSTANCES0	CHAR10	CHAR	10	0	Instances
23	CACHE	☐	CACHE	CHAR5	CHAR	5	0	Cache

History

Last changed by/on	SAP	19990505
SAP Release Created in