Oracle DBA, How To, Error, Cause and Action

ORA-00273: media recovery of direct load data that was not logged

ORA-00273: media recovery of direct load data that was not logged

Cause:

A media recovery session encountered a table that was loaded by the direct loader without logging any redo information. Some or all of the blocks in this table are now marked as corrupt.


Action:

The table must be dropped or truncated so that the corrupted blocks can be reused. If a more recent backup of the file is available, try to recover this file to eliminate this error.

No comments:

Post a Comment

Thanks for your comment.