Re: Create table UNRECOVERABLE and redo logs

Mike,

Once a backup of the datafile(s) containing the table has been performed, recovery would mean restoring the file(s) that contain the loaded table. Redo log would then be applied to rollforward the contents of the file(s) from that point in time to the desired recovery point. Therefore, after performing such a load, you should save the source data until at least the first subsequent backup.

Regards,
Andrew May
Quest Software.

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
>
> ==================
> Mike Rushton
> ==================
Received on Thu Apr 23 1998 - 23:30:12 CDT