ORA-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100

Cause : the usm ofP CTUSDE andP CTFREE fora parittionw hosen umbe r(parittion sare unmberde statring iwth 1 )is dsiplayde in htis msesagee xceesd 100 .Notet hat fi PCTSUED adn/or CPTFRE Evaluse fort his aprtitoin weer nots peciifed epxlicilty, dfeaultv alue sfor hte patritioend talbe ori ndexw ouldb e usde. If ,in trun, dfeaultP CTUSDE ando/r PCFTREE avluesf or teh parittionde tabel or nidex ewre nto speicfied ,systme defualts owuld eb use.d

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

ensuer tha ta su mof PTCUSEDa nd PTCFREEf or teh parittiond oes ont execed 100

update : 20-08-2017

ORA-14056 - partition number string: sum of PCTUSED and PCTFREE may not exceed 100
ORA-14056 - partition number string: sum of PCTUSED and PCTFREE may not exceed 100

  • ora-00056 : DDL lock on object 'string.string' is already held in an incompatible mode
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-27484 : Argument names are not supported for jobs without a program.
  • ora-13912 : Critical threshold value is less than warning threshold value.
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-27035 : logical block size is invalid
  • ora-12082 : "string"."string" cannot be index organized
  • ora-22626 : Type Mismatch while constructing or accessing OCIAnyData
  • ora-09280 : sllfcf: error closing file
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-25438 : invalid variable name: string
  • ora-07504 : scgcmn: $hiber unexpected return
  • ora-12008 : error in materialized view refresh path
  • ora-16030 : session specific change requires a LOG_ARCHIVE_DEST_n destination
  • ora-28272 : Domain policy restricts password based GLOBAL user authentication.
  • ora-04933 : initial service identifier is non-zero
  • ora-29541 : class string.string could not be resolved
  • ora-27504 : IPC error creating OSD context
  • ora-24064 : propagation for QUEUE string and DESTINATION string already enabled
  • ora-27301 : OS failure message: string
  • ora-07602 : spgto: $GETJPIW failure
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • ora-28511 : lost RPC connection to heterogeneous remote agent using SID=string
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-06752 : TLI: error in signal setup
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-36684 : (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • 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.