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.

Solution doesn't works for you?
POST your error in our discussion panel below.
Our DBA team will be happy to help you :)

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments