ORA-01486: size of array element is too large

Cause : You tried to bind a data value which was either too large for the datatype (for example, NUMBER) or was greater than 4000 bytes (for example, VARCHAR or LONG).

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


update : 26-07-2017

ORA-01486 - size of array element is too large
ORA-01486 - size of array element is too large

  • ora-23341 : user function required
  • ora-12198 : TNS:could not find path to destination
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-02091 : transaction rolled back
  • ora-08006 : specified row no longer exists
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-12725 : unmatched parentheses in regular expression
  • ora-38703 : Type string in header is not a flashback database log file.
  • ora-02486 : Error in writing trace file string
  • ora-19718 : length for command id longer than string
  • ora-01914 : invalid auditing option for sequence numbers
  • ora-19012 : Cannot convert XML fragment to the required datatype
  • ora-12665 : NLS string open failed
  • ora-01653 : unable to extend table string.string by string in tablespace string
  • ora-38502 : invalid XML tag: string
  • ora-12872 : First slave parse gave different plan
  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-06039 : NETDNT: connect failed
  • ora-25199 : partitioning key of a index-organized table must be a subset of the primary key
  • ora-25437 : duplicate table value for table alias: string
  • ora-01347 : Supplemental log data no longer found
  • ora-38410 : schema extension not allowed for the table name
  • ora-38602 : FI invalid input cursor
  • ora-07220 : slspool: wait error.
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-14109 : partition-extended object names may only be used with tables
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-24271 : translation type must be either T, S or M
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • 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.