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



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

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-15048: ASM internal files cannot be deleted

1 Answers  


ORA-16060: Log file is current

1 Answers  


LPX-00410: unable to resolve the variable reference

1 Answers  


QSM-01014: top level operator in WHERE clause of the query is an OR

1 Answers  


NNO-00306: server shutdown countdown aborted

1 Answers  






KUP-11001: files not from the same unload operation

1 Answers  


ORA-07488: scgrcl: lock manager not initialized.

1 Answers  


IMP-00009: abnormal end of export file

1 Answers  


ORA-01324: cannot add file string due to DB_ID mismatch

1 Answers  


O2I-00101: Invalid value for the USERID parameter

1 Answers  


RMAN-10029: unexpected return code number from PL/SQL execution

1 Answers  


ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine

1 Answers  


Categories