Oracle Database 12c New Features

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.