Oracle Solution for Error ora-14103

ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

What triggered the Error:

A statement contained both [NO]LOGGING and [UN]RECOVERABLE clauses which is disallowed.

What should we do to fix it:

Remove one of the offending clauses. [UN]RECOVERABLE is being deprecated in V8 and will be obsoleted in V9. To duplicate semantics of UNRECOVERABLE clause, create an object with NOLOGGING option and then ALTER it specifying LOGGING. To duplicate semantics of RECOVERABLE clause, create an object with LOGGING option.