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 : 27-06-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-32631 : illegal use of objects in MODEL
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-27374 : insufficient privileges on event source queue
  • ora-07682 : sou2os: set kernel dispatch fail err
  • ora-00255 : error archiving log string of thread string, sequence # string
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • ora-07220 : slspool: wait error.
  • ora-32321 : REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE
  • ora-09929 : GLB of two labels is invalid
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-30479 : Summary Advisor error string
  • ora-24791 : invalid transaction start flags
  • ora-12608 : TNS: Send timeout occurred
  • ora-26726 : logical standby and DOWNSTREAM_REAL_TIME_MINE are incompatible
  • ora-01372 : Insufficient processes for specified LogMiner operation
  • ora-14613 : Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed
  • ora-15082 : ASM failed to communicate with database instance
  • ora-26677 : Streams downstream capture process string cannot proceed
  • ora-12033 : cannot use filter columns from materialized view log on "string"."string"
  • ora-09301 : osncon: local kernel only supported in standard mode
  • ora-23375 : feature is incompatible with database version at string
  • ora-36763 : (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.
  • ora-06304 : IPA: Message receive error
  • ora-02213 : duplicate PCTUSED option specification
  • ora-12526 : TNS:listener: all appropriate instances are in restricted mode
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-07706 : error in archive text: need disk file name
  • ora-23315 : repcatlog version or request string is not supported by version string
  • ora-38431 : could not evaluate subexpression "string" for rowid "string"
  • ora-15046 : ASM file name 'string' is not in single-file creation form
  • 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.