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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01106: MV, string, is stale with respect to some partition(s) in the base table(s)

1 Answers  


TNS-12153: TNS:not connected

1 Answers  


SQL*Loader-00477: REF directive for field string requires at least two arguments

1 Answers  


ORA-12093: invalid interim table "string"."string"

2 Answers  


ORA-24904: invalid callback attribute passed into OCI call

1 Answers  






PCC-02361: Use of ARRAYLEN with SQL bind arrays is ignored

1 Answers  


CLSS-02200: Received node deletion request for active node string.

1 Answers  


ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based

1 Answers  


NNO-00071: cannot construct cache checkpoint file name

1 Answers  


ORA-12570: TNS:packet reader failure

1 Answers  


ORA-02453: duplicate HASH IS specification

1 Answers  


NNL-00962: Cache checkpoint failures: number

1 Answers  


Categories