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 : 27-06-2017
ORA-15057

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-27124 : unable to detach from shared memory segment
  • ora-38436 : attribute set used for an Expression set may not be modified.
  • ora-39769 : finish is not allowed with an incompletely loaded last row
  • ora-26534 : collision: tranID number ignored and purged
  • ora-13841 : SQL profile named string already exists for a different signature/category pair
  • ora-12096 : error in materialized view log on "string"."string"
  • ora-29706 : incorrect value string for parameter ACTIVE_INSTANCE_COUNT
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-00602 : internal programming exception
  • ora-02084 : database name is missing a component
  • ora-24439 : success with PLSQL compilation warning
  • ora-28291 : No Kerberos Principal Value found.
  • ora-28507 : error in data dictionary view string
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-01297 : redo version mismatch between dictionary string and logfiles
  • ora-19105 : invalid XQueryX: expected text node - got string
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • ora-24809 : amount specified will not fit in the lob buffers
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-15179 : missing or invalid alias name
  • ora-07280 : slsget: unable to get process information.
  • ora-16619 : health check timed out
  • ora-25437 : duplicate table value for table alias: string
  • ora-24794 : no active DTP service found
  • ora-02271 : table does not have such constraint
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-19724 : snapshot too old: snapshot time is before file string plug-in time
  • ora-00255 : error archiving log string of thread string, sequence # string
  • ora-01562 : failed to extend rollback segment number 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.