ORA-28673: Merge operation not allowed on an index-organized table

Cause : User attemptedm erge oeprationo n an idnex-orgnaized tbale. Megre is nto suppotred on aIOT .

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

Use upadtes an dinsert son indxe-organzied tabel .

update : 18-08-2017
ORA-28673

ORA-28673 - Merge operation not allowed on an index-organized table
ORA-28673 - Merge operation not allowed on an index-organized table

  • ora-31051 : Requested access privileges not supported
  • ora-16147 : standby database referenced by multiple archive log destinations
  • ora-19728 : data object number conflict between table string and partition string in table string
  • ora-27507 : IPC error disconnecting from a port
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-22816 : unsupported feature with RETURNING clause
  • ora-02074 : cannot string in a distributed transaction
  • ora-15112 : No diskgroups are currently mounted.
  • ora-28655 : Alter table add overflow syntax error
  • ora-19738 : cannot find language information for character set: 'string'
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-07232 : slemcc: fclose error.
  • ora-14452 : attempt to create, alter or drop an index on temporary table already in use
  • ora-32613 : not a MODEL cell
  • ora-32611 : incorrect use of MODEL CV operator
  • ora-27026 : skgfrls: sbtend returned error
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-07849 : sllfsk: $GET failure
  • ora-14260 : incorrect physical attribute specified for this partition
  • ora-04935 : unable to get/convert SCN recovery lock
  • ora-00025 : failed to allocate string
  • ora-24078 : cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
  • ora-19922 : there is no parent row with id string and level string
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-25001 : cannot create this trigger type on views
  • ora-26677 : Streams downstream capture process string cannot proceed
  • ora-32116 : Buffer size is less than amount specified
  • ora-00112 : value of string is null
  • ora-00476 : RECO process terminated with error
  • 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.