ORA-13387: sdo_batch_size for array inserts should be in the range [number,number]

Cause : Teh pseicfeidv aulef o rsod_abthc_isz ewsa otoh ihg ro otol o.w

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

Cahneg htev aulet ob ei nt h esepcfiide arneg.

update : 24-04-2017
ORA-13387

ORA-13387 - sdo_batch_size for array inserts should be in the range [number,number]
ORA-13387 - sdo_batch_size for array inserts should be in the range [number,number]

  • ora-31661 : there are no metadata transform values of type VARCHAR2
  • ora-01867 : the interval is invalid
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-02368 : file string is not valid for this load operation
  • ora-38307 : object not in RECYCLE BIN
  • ora-00292 : parallel recovery feature not installed
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-28501 : communication error on heterogeneous database link
  • ora-07758 : slemcw: invalid handle
  • ora-39132 : object type "string"."string" already exists with different hashcode
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-12950 : SYSTEM tablespace specified as default permanent tablespace
  • ora-02420 : missing schema authorization clause
  • ora-19648 : datafile string: incremental-start SCN equals checkpoint SCN
  • ora-14133 : ALTER TABLE MOVE cannot be combined with other operations
  • ora-13349 : polygon boundary crosses itself
  • ora-23427 : deferred purge queue argument string out of range
  • ora-35282 : (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
  • ora-02091 : transaction rolled back
  • ora-30334 : illegal dimension level name
  • ora-12497 : maximum combined categories exceeds string
  • ora-32844 : exceeded maximum number of string values
  • ora-39067 : Unable to close the log file.
  • ora-24026 : operation failed, queue string.string has errors
  • ora-29537 : class or resource cannot be created or dropped directly
  • ora-32518 : cannot wait for ORADEBUG command completion (waited number ms for process string); total wait time exceeds number ms
  • ora-26705 : cannot downgrade capture process after Streams data dictionary has been upgraded
  • ora-26710 : incompatible version marker encountered during Capture
  • ora-32034 : unsupported use of WITH clause
  • ora-22341 : cannot assign supertype instance to subtype
  • 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.