How to fix the Oracle error ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW?

In this post, you’ll learn more about the Oracle ErrorORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW

Reason for the Error ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW

Attempt to specify LOGGING for a Alter Table Add Overflow.

How to fix the Error ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW ?

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

don’t do that