How to fix the Oracle error ORA-32592: all columns in log group can not be no log columns?

In this post, you’ll learn more about the Oracle ErrorORA-32592: all columns in log group can not be no log columns with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-32592: all columns in log group can not be no log columns

Reason for the Error ORA-32592: all columns in log group can not be no log columns

A supplemental log group must have at least one column of scalar type that is not marked as no log.

How to fix the Error ORA-32592: all columns in log group can not be no log columns ?

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

Redefine the supplemental log group with at least one column of scalar type that is not marked as no log.