How to fix the Oracle error ORA-26767: Not enough redo log information for LogMiner?

In this post, you’ll learn more about the Oracle ErrorORA-26767: Not enough redo log information for LogMiner with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26767: Not enough redo log information for LogMiner

Reason for the Error ORA-26767: Not enough redo log information for LogMiner

Direct-path SQL with NOLOGGING option or a SQL*Loader operation with UNRECOVERABLE clause was specified for the table.

How to fix the Error ORA-26767: Not enough redo log information for LogMiner ?

You can fix this error in Oracle by following the below steps

Remove the capture rule for the table and restart capture.