SAP ABAP Table DBA_TABLES (Oracle: Row Structure of dba_tables)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
     ⤷ SOMO (Package) Oracle Monitor
Basic Data
Table Category INTTAB    Structure 
Structure DBA_TABLES   Table Relationship Diagram
Short Description Oracle: Row Structure of 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 TABLEOWNER CHAR30 CHAR 30   0   Oracle: dba_tables.owner  
2 TABLE_NAME TABLENAMEO CHAR30 CHAR 30   0   Oracle: dba_tables.table_name?  
3 TSP_NAME TSPNAMEORA CHAR30 CHAR 30   0   Oracle: dba_tables.tablespace_name  
4 CLSTR_NAME CLUSTERNME CHAR30 CHAR 30   0   Oracle: dba_tables.cluster_name  
5 IOT_NAME IOTNAME CHAR30 CHAR 30   0   Oracle: dba_tables.iot_name  
6 PCT_FREE PCTFREE DEC17 DEC 17   0   Oracle: dba_tables.pct_free  
7 PCT_USED PCTUSEDORA DEC17 DEC 17   0   Oracle: dba_tables.pct_used  
8 INI_TRANS INITRANS DEC17 DEC 17   0   Oracle: dba_tables.ini_trans  
9 MAX_TRANS MAXTRANS DEC17 DEC 17   0   Oracle: dba_tables.max_trans  
10 INITEXTENT INITEXT DEC17 DEC 17   0   Oracle: dba_tables.initial_extent  
11 NEXTEXTENT NEXTEXT DEC17 DEC 17   0   Oracle: dba_tables.next_extent  
12 MINEXTS MINEXTENT DEC17 DEC 17   0   Oracle: dba_tables.min_extents  
13 MAXEXTS MAXEXTENT DEC17 DEC 17   0   Oracle: dba_tables.max_extents  
14 PCTINCR PCTINCR DEC17 DEC 17   0   Oracle: dba_tables.pct_increase  
15 FREELISTS FREELISTNO DEC17 DEC 17   0   Oracle: dba_tables.freelists  
16 FL_GROUPS FREELGROUP DEC17 DEC 17   0   Oracle: dba_tables.freelist_groups  
17 LOGGING LOGGING CHAR3 CHAR 3   0   Oracle: dba_tables.logging  
18 BACKED_UP BACKEDUP CHAR1 CHAR 1   0   Oracle: dba_tables.backed_up  
19 NUM_ROWS NUMROWORA DEC17 DEC 17   0   Oracle: dba_tables.num_rows  
20 BLOCKS NUMBLOCKS DEC17 DEC 17   0   Oracle: dba_tables.blocks  
21 EMPTBLOCKS EMPBLOCKS DEC17 DEC 17   0   Oracle: dba_tables.empty_blocks  
22 AVG_SPACE AVGSPACE DEC17 DEC 17   0   Oracle: dba_tables.avg_space  
23 CHAIN_CNT CHAINCNT DEC17 DEC 17   0   Oracle: dba_tables.chain_cnt  
24 AVGROWLEN AVGROWLEN DEC17 DEC 17   0   Oracle: dba_tables.avg_row_len  
25 AVGFLBLOCK AVGFLBLK DEC17 DEC 17   0   Oracle: dba_tables.avg_space_freelist_blocks  
26 NUMFLBLOCK NUMFLBLK DEC17 DEC 17   0   Oracle: dba_tables.num_freelist_blocks  
27 DEGREE DEGREEORA CHAR10 CHAR 10   0   Oracle: dba_tables.degree  
28 INSTANCES INSTORA CHAR10 CHAR 10   0   Oracle: dba_tables.instances  
29 CACHE TBLCACHE CHAR5 CHAR 5   0   Oracle: dba_tables.cache  
30 TABLE_LOCK TBLLOCK CHAR8 CHAR 8   0   Oracle: dba_tables.table_lock  
31 SAMPLESIZE SAMPLESIZE DEC17 DEC 17   0   Oracle: dba_tables.sample_size  
32 LASTANALYZ DATEORA CHAR14 CHAR 14   0   Oracle: dba_tables.last_analyzed  
33 PARTITIONE PARTITION CHAR3 CHAR 3   0   Oracle: dba_tables.partitioned  
34 IOT_TYPE IOTTYPE CHAR12 CHAR 12   0   Oracle: dba_tables.iot_type  
35 TMP TEMPORARY CHAR1 CHAR 1   0   Oracle: dba_tables.temporary  
36 NESTED NESTEDORA CHAR3 CHAR 3   0   Oracle: dba_tables.nested  
37 BUFFPOOL BUFFPOOL CHAR7 CHAR 7   0   Oracle: dba_tables.buffer_pool  
History
Last changed by/on SAP  20070813 
SAP Release Created in