only one LOGGING or NOLOGGING clause may be specified

Solution ID:ORA-14102

Type: Oracle

Cause

LOGGING was specified more than once, NOLOGGING was specified more than once, or both LOGGING and NOLOGGING were specified.

Actions

Ensure that all the rows in the segment qualify for the partition. Perform the alter table operation with the NO CHECKING option. Run ANALYZE table VALIDATE on that partition to find out the invalid rows and delete them.

Try the following links for this error:


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


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


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


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


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


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


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