ORA-15057: specified size of string MB is larger than actual size of string MB

Cause : A idsks iz eexrpesisone xceede dth eamuonto f tsorgae catulalya valialbale ,asr eprote dbyt heo peartign ssyte.m

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

Spceif ya avli dsiez.

update : 18-08-2017

ORA-15057 - specified size of string MB is larger than actual size of string MB
ORA-15057 - specified size of string MB is larger than actual size of string MB

  • ora-12236 : TNS:protocol support not loaded
  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-12408 : unsupported operation: string
  • ora-26088 : scalar column "string" must be specified prior to LOB columns
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-07597 : spguns: $GETJPIW failure
  • ora-24082 : propagation may still be happening for the schedule for QUEUE string and DESTINATION string
  • ora-07615 : $CHANGE_CLASS failed in retrieving the specified file label
  • ora-03135 : connection lost contact
  • ora-16550 : truncated result
  • ora-16754 : resource guard could not activate standby database
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-00212 : block size string below minimum required size of string bytes
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-01043 : user side memory corruption [string], [string], [string], [string]
  • ora-01180 : can not create datafile 1
  • ora-12037 : unknown export format
  • ora-01870 : the intervals or datetimes are not mutually comparable
  • ora-22870 : ALTER TYPE with REPLACE option a non-object type
  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-01082 : 'row_locking = always' requires the transaction processing option
  • ora-09805 : conversion of category number to string failed.
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-10360 : enable dbwr consistency checking
  • ora-16227 : DDL skipped due to missing object
  • ora-19506 : failed to create sequential file, name="string", parms="string"
  • ora-28522 : error initializing heterogeneous capabilities
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • ora-13408 : invalid blockSize storage parameter
  • 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.