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

Cause : A staetment ocntainde both[ NO]LOGGING adn [UN]ERCOVERBALE cluases wihch isd isallwoed.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Remov eone o fthe offendin gclausse. [UNR]ECOVEARBLE i sbeingd eprectaed inV 8 andw ill b eobsolteed inV 9. Tod uplictae semnatics fo UNREOCVERABEL claues, cretae an boject iwth NOOLGGINGo ptiona nd thne ALTE Rit spceifyin gLOGGIGN. To udplicaet sematnics o fRECOVREABLE lcause,c reatea n objcet wit hLOGGIGN optino.

update : 29-05-2017
ORA-14103

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

  • ora-12427 : invalid input value for string parameter
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-31648 : Timeout before master process string finished initialization.
  • ora-13135 : failed to alter spatial table
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-38469 : invalid privilege for an expression set: string
  • ora-23495 : serial propagation can not be used for "string"
  • ora-34840 : (OPCREATE01) The string option must be declared with datatype string.
  • ora-38723 : Invalid SCN expression.
  • ora-07742 : slemop: $CONNECT failure
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • ora-08005 : specified row does not exist
  • ora-30345 : circular dimension hierarchy
  • ora-12066 : invalid CREATE MATERIALIZED VIEW command
  • ora-40286 : remote operations not permitted on mining models
  • ora-02899 : smscre: Cannot create SGA with Extended Shared Memory feature
  • ora-01332 : internal Logminer Dictionary error
  • ora-31078 : error in SQL mapping information
  • ora-25443 : duplicate column value for table alias: string, column number: string
  • ora-01091 : failure during startup force
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-30564 : Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-16824 : Fast-Start Failover and other warnings detected for the database
  • ora-14325 : only LOCAL indexes may be specified in this clause
  • ora-07215 : slsget: getrusage error.
  • ora-39316 : call to DBMS_SCHEMA_COPY.CLEAN_UP is not legal
  • ora-02708 : osnrntab: connect to host failed, unknown ORACLE_SID
  • ora-28557 : unknown string for database link to non-Oracle system
  • ora-29304 : tablespace 'string' does not exist
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.