How can I transform a (Relative) Database Block Address (R)DBA to a (relative) file_id and block_id or vice versa?
Several dumps or tracefiles in the area of block corruptions show a rowid, a DBA (database block address) or a RDBA (relative database block address). This needs to be splitted in its components like object, file, block or slot. For selects via rowid a row id need to be created. The object_id is the corresponding column in dba_objects. A slot is the number of a row within the block. The first row in a Block has number 0. The following functions work SYSTEM INDEPENDENTLY. They just transform the data to another format and do NOT do any existance check of files, objects etc. Using the same syntax on any system produces always the same result.
Related Questions
- Can I import names and address from my database into the SLP application software and can I export names and addresses from the SLP application software into my database?
- Can SAP APO and SAP R/3 be installed on the same server and use the same database?
- In a Dodge Stealth R/T or Mitsubishi 3000GT VR-4, what is the block made of?
