Re: Create table UNRECOVERABLE and redo logs

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Thu, 23 Apr 1998 22:58:17 GMT
Message-ID: <353fc786.15922453@www.sigov.si>

On Thu, 23 Apr 1998 18:45:38 GMT, mike_at_mrush.demon.co.uk (Mike Rushton) wrote:

>If you create a table using the 'unrecoverable' option no data is written to the
>redo logs. If, however you add additional records to the table, i presume that
>records ARE written to the redo logs.
>
>If a database recovery is then perfomed, will the table
>
>a. Not exist
>b. Exist but be empty
>c. Contain all the data
>d. Contain only the additional data
>
>Please help me understand

Interested question. I experimented a litle and my conclusions are:

After the recovery, the data dictionary was avare of the experiment table, i.e. "DESC experiment_table" worked, it was present in DBA_SEGMENTS, DBA_EXTENTS, DBA_TABLES etc. However, when I tried to select from it, I've got the following ora error: "ORA-01578: Oracle data block corrupted (file # nn, block # mm)". This block was occupied exactly with the experiment table extent. When I run db verify utility (dbverf) over this file, it reported one page as being software corupted. Then I dropped the table ("DROP TABLE ..." worked) and after that dbverf didn't find any corruptions in the database files.

So the answer to your question is: table exists, but is unusable. (I tested this on Personal Oracle 7.3.2/Win95).

>==================
> Mike Rushton
>==================

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Apr 23 1998 - 17:58:17 CDT