ORA-14103: LOGGING/NOLOGGING may not be combined with
RECOVERABLE/UNRECOVERABLE
- 1 Answers
- 3360 Views
- I also Faced
- E-Mail Answers
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 |
ORA-32331: type "string"."string" is incompatible with the master site
ORA-16196: database has been previously opened and closed
ORA-01029: internal two task error
ORA-07215: slsget: getrusage error.
TNS-00013: INTCTL: error while performing NS disconnect command
RMAN-08526: channel string: string
IMG-00809: usage of IMGSimilar is incorrect
TNS-12665: NLS string open failed
EXP-00011: %s.string does not exist
ORA-29803: missing ANCILLARY keyword
ORA-01599: failed to acquire rollback segment (string), cache space is full
ORA-23329: successful user-provided ddl but no materialized view "string"."string"
Oracle Errors 
