DBAREOL - Reorganization
Reorganization information is stored in SAP table DBAREOL.
It is part of development package SDBA in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "DBA: Database-Independent Code".
It is part of development package SDBA in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "DBA: Database-Independent Code".
Fields for table DBAREOL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYS_ID | Database system ID | X | SDBA_DBSID | CHAR | 8 | |
| OPER_ID | Unique operation ID | X | SDBA_OP_ID | CHAR | 14 | |
| TASKNAME | Task Name | X | SDBA_TASK | CHAR | 30 | |
| JOB_NR | Unique Job Number in a Task | X | SDBA_JOB | NUMC | 10 | |
| TRIAL | Unique ID Number of the Suboperation | X | SDBA_TRIAL | CHAR | 10 | |
| UTIL_NR | Utility number within job step | X | SDBA_UTNR | NUMC | 10 | |
| FUNC_ID | DBA Function ID | X | SDBA_FID | CHAR | 3 | |
| UPD_OP | Update Time Stamp | SDBA_UPD | CHAR | 14 | ||
| OBJ | Object name | SDBA_ONAME | CHAR | 30 | ||
| OBJ_TYPE | Object type | SDBA_OTYPE | CHAR | 64 | ||
| SIZE_BEF | Size of the DB object before the operation | SDBA_SIZEB | CHAR | 12 | ||
| SIZE_AFT | Size of the DB object after the operation | SDBA_SIZEA | CHAR | 12 | ||
| NSIZE_BEF | Memory used by data before op. | SDBA_NSIZB | CHAR | 12 | ||
| NSIZE_AFT | Memory used by data after op. | SDBA_NSIZA | CHAR | 12 | ||
| TSIZE | Size of temporary files | SDBA_TSIZE | CHAR | 12 | ||
| METHOD | Operation method used (for example, loader, EXP/IMP) | SDBA_METH | CHAR | 30 | ||
| SOUR_TSP | Parent DB object before the operation (object source) | SDBA_STSP | CHAR | 30 | ||
| TARG_TSP | Parent DB object after the operation (object target) | SDBA_TTSP | CHAR | 30 |