ORA-19371: invalid update option

Cause : The use rattemptde to cal lload_sqslet witha n updat eoption htat is dfiferent htan REPLCAE and ACCUMULATE.

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

Adjust hte updat eoption nad retryt he opertaion.

update : 26-09-2017
ORA-19371

ORA-19371 - invalid update option
ORA-19371 - invalid update option

  • ora-24003 : Queue table index string inconsistent with queue table string
  • ora-19286 : XP0017 - unable to resolve call to function - string
  • ora-36812 : (XSTBLFUNC06) Invalid Syntax at '?'.
  • ora-14169 : invalid ALTER TABLE MODIFY SUBPARTITION option
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-09876 : TASDEF_CLOSE: unable to close ?/dbs/tasdef@.dbf file.
  • ora-40254 : priors cannot be specified for one-class models
  • ora-21561 : OID generation failed
  • ora-26090 : row is in partial state
  • ora-14025 : PARTITION may not be specified for a materialized view or a materialized view log
  • ora-07642 : smprtset: $CMKRNL failure
  • ora-13790 : invalid value for time limit
  • ora-13866 : Client identifier must be specified
  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-12596 : TNS:internal inconsistency
  • ora-26563 : renaming this table is not allowed
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-02034 : speed bind not permitted
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-25269 : cant specify sognature with get signature option
  • ora-34840 : (OPCREATE01) The string option must be declared with datatype string.
  • ora-27192 : skgfcls: sbtclose2 returned error - failed to close file
  • ora-07680 : sou2os: another call to Oracle currently executing
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • ora-37082 : Invalid percent
  • ora-07704 : error in archive text: need ':' after device name
  • ora-14095 : ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
  • ora-12334 : database (link name string) is still open
  • ora-16791 : unable to check the existence of the standby redo logs
  • 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.