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 : 24-05-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-07623 : smscre: $CRMPSC failure
  • ora-24154 : rule string.string already in rule set string.string
  • ora-30689 : improper value for ORA_DEBUG_JDWP
  • ora-06707 : TLI Driver: connection failed
  • ora-09842 : soacon: Archmon unable to create named pipe.
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-32007 : internal
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-26019 : Column string in table string of type string not supported by direct path
  • ora-01929 : no privileges to GRANT
  • ora-32110 : Connection not specified
  • ora-16563 : unable to add value, syntax error at "string"
  • ora-13000 : dimension number is out of range
  • ora-09818 : Number is too large
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-01920 : user name 'string' conflicts with another user or role name
  • ora-14517 : subpartition of index 'string.string' is in unusable state
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-15060 : template "string" does not exist
  • ora-12659 : Error received from other process
  • ora-13709 : Required parameter "string" must be set before execution.
  • ora-01905 : STORAGE keyword expected
  • ora-12989 : invalid value for checkpoint interval
  • ora-06959 : Buffer I/O quota is too small
  • ora-32059 : deadlock detected on mapping structures
  • ora-12609 : TNS: Receive timeout occurred
  • ora-24435 : Invalid Service Context specified.
  • ora-02789 : Maximum number of files reached
  • 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.