Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create table UNRECOVERABLE and redo logs

Create table UNRECOVERABLE and redo logs

From: Mike Rushton <mike_at_mrush.demon.co.uk>
Date: Thu, 23 Apr 1998 18:45:38 GMT
Message-ID: <353f81b7.1561483@news.demon.co.uk>


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

  1. Not exist
  2. Exist but be empty
  3. Contain all the data
  4. Contain only the additional data

Please help me understand


   Mike Rushton


Received on Thu Apr 23 1998 - 13:45:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US