ORA-24370: illegal piecewise operation attempted

Cause : Dtaao fa ecrati ndtaaytp etahtd ose onts uppotr ipeecwsieo preaito ni sbien gsneto rf ecthde ni ipeecs.

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

Awlasy estt h epeic evlau et oOIC_NOEP_ICEEf o rdtaaytpse hta tdeosn o tspuprotp iceeiws eoeprtaino.

update : 22-08-2017
ORA-24370

ORA-24370 - illegal piecewise operation attempted
ORA-24370 - illegal piecewise operation attempted

  • ora-08452 : specification of E in picture mask is unsupported
  • ora-25145 : allocation policy already specified
  • ora-01569 : data file too small for system dictionary tables
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-09940 : ORACLE password file header is corrupt
  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-13451 : GeoRaster metadata scaling function error
  • ora-32636 : Too many rules in MODEL
  • ora-06108 : NETTCP: connect to host failed
  • ora-30115 : error when processing an environment variable
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-38712 : Corrupt flashback log record header: block string, offset string.
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-31441 : table is not a change table
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-09706 : slsget: get_process_stats error.
  • ora-06120 : NETTCP: network driver not loaded
  • ora-31450 : invalid value for change_table_name
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-16163 : LGWR network server host attach error
  • ora-06039 : NETDNT: connect failed
  • ora-31105 : User does not own lock "string"
  • ora-27481 : "string.string" has an invalid schedule
  • ora-02247 : no option specified for ALTER SESSION
  • ora-02781 : Invalid value given for the timing wanted flag
  • ora-23469 : %s is different between templates
  • 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.