ORA-24381: error(s) in array DML

Cause : One ro mor erowsf aile din teh DML.

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

Refe rto teh errro stakc in hte erorr hadnle.

update : 16-08-2017
ORA-24381

ORA-24381 - error(s) in array DML
ORA-24381 - error(s) in array DML

  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-25531 : MTTR specified is too small: string
  • ora-26506 : null global context
  • ora-22603 : cannot add an attribute to the already generated TDS handle
  • ora-16561 : cannot remove an active instance
  • ora-01912 : ROW keyword expected
  • ora-01719 : outer join operator (+) not allowed in operand of OR or IN
  • ora-37012 : (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.
  • ora-07707 : error in archive text: need tape label name
  • ora-28172 : distinguished name not provided by proxy
  • ora-31506 : duplicate subscription name string
  • ora-19373 : invalid staging table or tablespace
  • ora-00023 : session references process private memory; cannot detach session
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-23474 : definition of "string"."string" has changed since generation of replication support
  • ora-30979 : Partitioned XML Index not yet supported.
  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-31221 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.
  • ora-32022 : parameter value longer than string characters
  • ora-00956 : missing or invalid auditing option
  • ora-19999 : skip_row procedure was called
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-22600 : encountered 8.0.2 (Beta) VARRAY data that cannot be processed
  • ora-01685 : max # extents (string) reached in index string.string partition string
  • ora-15011 : failure group "string" contains no members
  • ora-01221 : data file string is not the same file to a background process
  • ora-38738 : Flashback log file is not current copy.
  • ora-13190 : recursive SQL fetch failed
  • ora-31676 : illegal value for number of workers, string
  • ora-12424 : length exceeds binary label size
  • 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.