DBABD - Information About the Data Files (Oracle)
Information About the Data Files (Oracle) information is stored in SAP table DBABD.
It is part of development package SDBO in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "Database Administration: Oracle-Specific Components".
It is part of development package SDBO in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "Database Administration: Oracle-Specific Components".
Fields for table DBABD
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 | |
| REC_NR | Unique record number for file | X | SDBA_RECNR | CHAR | 4 | |
| UPD_OP | Update Time Stamp | SDBA_UPD | CHAR | 14 | ||
| DBF_ID | File ID (Oracle) | SDBA_FI_ID | CHAR | 4 | ||
| TSP_NAME | Tablespace name | SDBA_TSP | CHAR | 30 | ||
| TSP_STATUS | Tablespace status | SDBA_TSSTA | CHAR | 1 | ||
| DBF_STATUS | Data file status | SDBA_FISTA | CHAR | 1 | ||
| TIME_BEG | Data file backup start time | SDBA_BEGBU | CHAR | 14 | ||
| TIME_END | End of data file backup | SDBA_ENDBU | CHAR | 14 | ||
| REDO_BEG | Redo log number at start of data file backup | SDBA_RDBEG | CHAR | 8 | ||
| REDO_END | Redo log number at end of data file backup | SDBA_RDEND | CHAR | 8 | ||
| VOLUME | Name of backup volume | SDBA_VOL | CHAR | 10 | ||
| FILE_POS | Position of file on storage device | SDBA_FPOS | NUMC | 4 | ||
| COMP_RATE | Compression rate | SDBA_COMPR | CHAR | 10 | ||
| UTIL_BID | SID of a backup file (using external backup program) | SDBA_BID | CHAR | 16 | ||
| FILE_NAME | Complete path including file name | SDBA_PATH | CHAR | 255 | ||
| FILE_SIZE | File size | SDBA_FI_SI | CHAR | 12 | ||
| INTERNAL | For internal purposes | SDBA_INT | CHAR | 255 |