SAP ABAP Table DBABL (Information About Archive Log Files (Oracle))
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
⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
⤷ SDBO (Package) Database Administration: Oracle-Specific Components
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | DBABL | Table Relationship Diagram |
Short Description | Information About Archive Log Files (Oracle) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | S | System table, maint. only by SAP, change = modification |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | SYS_ID | SDBA_DBSID | CHAR8 | CHAR | 8 | 0 | Database system ID | ||
2 | OPER_ID | SDBA_OP_ID | CHAR14 | CHAR | 14 | 0 | Unique operation ID | ||
3 | TASKNAME | SDBA_TASK | SDBA_TASK | CHAR | 30 | 0 | Task Name | ||
4 | JOB_NR | SDBA_JOB | SDBA_JOB | NUMC | 10 | 0 | Unique Job Number in a Task | ||
5 | TRIAL | SDBA_TRIAL | CHAR10 | CHAR | 10 | 0 | Unique ID Number of the Suboperation | ||
6 | UTIL_NR | SDBA_UTNR | SDBA_UTNR | NUMC | 10 | 0 | Utility number within job step | ||
7 | FUNC_ID | SDBA_FID | SDBA_FUNCT | CHAR | 3 | 0 | DBA Function ID | ||
8 | REC_NR | SDBA_RECNR | CHAR4 | CHAR | 4 | 0 | Unique record number for file | ||
9 | UPD_OP | SDBA_UPD | SDBA_UPD | CHAR | 14 | 0 | Update Time Stamp | ||
10 | ARCH_FUNC | SDBA_AFU | SDBA_AFU | CHAR | 1 | 0 | Backup function | ||
11 | ARCH_NR | SDBA_ANR | CHAR8 | CHAR | 8 | 0 | Archive log sequence number | ||
12 | ARCH_TIME | SDBA_ATI | CHAR14 | CHAR | 14 | 0 | Offline redo log file creation time | ||
13 | ARCH_SCN | SDBA_ASC | CHAR16 | CHAR | 16 | 0 | First System Change Number (SCN) of Offline Redo Log File | ||
14 | THREAD_NR | SDBA_RTHRD | CHAR4 | CHAR | 4 | 0 | Oracle thread number of the offline redo log file | ||
15 | TIME_BEG | SDBA_BEGAR | SDBA_TSTMP | CHAR | 14 | 0 | Offline redo log file backup start time | ||
16 | TIME_END | SDBA_ENDAR | SDBA_TSTMP | CHAR | 14 | 0 | End of offline redo log file backup | ||
17 | VOLUME | SDBA_VOL | CHAR10 | CHAR | 10 | 0 | Name of backup volume | ||
18 | FILE_POS | SDBA_FPOS | NUMC4 | NUMC | 4 | 0 | Position of file on storage device | ||
19 | COMP_RATE | SDBA_COMPR | CHAR10 | CHAR | 10 | 0 | Compression rate | ||
20 | UTIL_BID | SDBA_BID | CHAR16 | CHAR | 16 | 0 | SID of a backup file (using external backup program) | ||
21 | ARCH_NAME | SDBA_ANA | CHAR255 | CHAR | 255 | 0 | Name of Saved Offline Redo Log File | ||
22 | ARCH_SIZE | SDBA_ASI | CHAR12 | CHAR | 12 | 0 | Size (Bytes) of Saved Offline Redo Log File | ||
23 | INTERNAL | SDBA_INT | CHAR255 | CHAR | 255 | 0 | For internal purposes |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |