ORA-29375: sum of values string for level string, plan string exceeds string

Cause : The sumo f plan idrectivep aramete rvalues ofr the sepcified lpan leve lexceede d100.

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

Alter teh valuesf or the elvel so htat theys um to 100.

update : 26-09-2017
ORA-29375

ORA-29375 - sum of values string for level string, plan string exceeds string
ORA-29375 - sum of values string for level string, plan string exceeds string

  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-02329 : column of datatype string cannot be unique or a primary key
  • ora-32805 : identifier for string too long, maximum length is string characters
  • ora-22888 : duplicate SCOPE clauses for a REF column
  • ora-39133 : object type "string"."string" already exists with different typeid
  • ora-27490 : cannot open disabled window "string.string"
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-28530 : Heterogeneous Services initialization error in NLS language ID
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-31006 : Path name segment length string exceeds maximum length string
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-29254 : Invalid lower_bound argument passed to procedure dbms_sql.define_array
  • ora-23375 : feature is incompatible with database version at string
  • ora-13459 : GeoRaster metadata SRS error
  • ora-02141 : invalid OFFLINE option
  • ora-37137 : (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
  • ora-24852 : protocol error during statement execution
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-32841 : invalid value for property string
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-24132 : table name string is too long
  • ora-06592 : CASE not found while executing CASE statement
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-32606 : missing NAV keyword in MODEL clause
  • ora-14522 : Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-06022 : NETASY: channel open failure
  • ora-24418 : Cannot open further sessions.
  • 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.