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-01343: LogMiner encountered corruption in the logstream

1 Answers  


ORA-14080: partition cannot be split along the specified high bound

1 Answers  


QSM-02077: mv log is newer than last full refresh

1 Answers  


ORA-02427: create view failed

1 Answers  


ORA-23361: materialized view "string" does not exist at master site

1 Answers  






TNS-12203: TNS:unable to connect to destination

1 Answers  


LPX-00652: SAX callback returns with error.

1 Answers  


TNS-12637: Packet receive failed

1 Answers  


ORA-16139: media recovery required

1 Answers  


ORA-02352: file truncated error

1 Answers  


ORA-12562: TNS:bad global handle

1 Answers  


KUP-04039: unexpected error while trying to find file string in string

1 Answers  


Categories