media recovery of direct load data that was not logged

Solution ID:ORA-00273

Type: Oracle

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.

Actions

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.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


https://community.oracle.com/message/1665265


https://community.oracle.com/message/1476723


Browse all solutions to database errors from Oracle, MS SQL, or MySQL