Wednesday, October 29, 2014

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

Error Code
ORA-00273

Description
Media recovery of direct load data that was not logged.

Cause
Possible cause of this error is, 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
To fix this issue, 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.

reference

No comments:

Post a Comment