timcc@csv.viccol.edu.au (09/13/90)
Environment: Oracle RDBMS V5.1.22.1, on a Sequent S27, running DYNIX V3.0.12 I have a dead Oracle database (dead to the extent that SYS.USERAUTH got renamed to USERAUTH_OLD, preventing anyone from accessing it). It was a test system, and can be restored, but it would be much less time consuming if I could extract some tables out of it, to be reloaded when a new database is initialised. I have posed the following questions to the Oracle Australia hotline, and they are working on them now (however they may not want to answer them due their technical nature), but perhaps someone out there can help me? 1. The field SYS.TABLES.TAB$RBA, which contains a table's Relative Block Address. What relationship does this have to the offset of the table's first data block in the actual database files? What about when there is more than one database file? 2. What is the format of a data extent block. This is the first data block of a table, and lists all the data extents of the table. 3. What is the difference between a logical data block and a physical data block? 4. What is the format of the header on each Oracle data block? 5. Is there anything else I might need to know in order to extract tables from a "dead" Oracle database (that is not documented in the Database Administrator's Guide)? Please respond by e-mail, as we do not receive this newsgroup locally. -- Tim Cook, Systems Administrator, Victoria College Computer Services Internet: timcc@viccol.edu.au UUCP: uunet!viccol.edu.au!timcc