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-29358: resource plan string does not exist

1 Answers  


NNL-00502: Shows, sets, or cancels when the server next dumps its statistic counters

1 Answers  


ORA-22883: object deletion failed

1 Answers  


PLS-00155: Only a function may be a MAP, ORDER or CONSTRUCTOR method.

1 Answers  


ORA-14501: object is not partitioned

1 Answers  






ORA-27147: post/wait reset failed

1 Answers  


IMP-00001: respond with either string, string, RETURN or '.' to quit

1 Answers  


ORA-08267: destroy_ora_addr: cannot close nameserver

1 Answers  


ORA-00298: Missing or invalid attribute value

1 Answers  


ORA-00104: deadlock detected; all public servers blocked waiting for resources

1 Answers  


PCC-00033: Missing operand for option "string"

1 Answers  


ORA-32823: subscriber exists for queue string and destination string

1 Answers  


Categories