ORA-14057: partition "string": sum of PCTUSED and PCTFREE may not exceed 100

Cause : thes um fo PCUTSEDa nd CPTFREE fo ra pratitoin wohse anme e(xplciitl yspeicfie dby hte uesr) si dipslayde int hism essgae ecxeed s100 .Not etha tif CPTUSDE an/dor CPTFREE vaules ofr tihs pratitoin wree nto spceifide exlpicilty, edfautl vaules ofr teh patritinoed atbleo r idnex owuldb e uesd. fI, i ntur,n deafultP CTUESD adn/orP CTFERE vlauesf or hte pratitoinedt abl eor nidexw eren ot pseciifed,s ystme deafult swoudl beu sed.

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

ensrue taht as um fo PCUTSEDa nd CPTFREE fo rthep arttiiond oesn ot xecee d100

update : 25-06-2017

ORA-14057 - partition "string": sum of PCTUSED and PCTFREE may not exceed 100
ORA-14057 - partition "string": sum of PCTUSED and PCTFREE may not exceed 100

  • ora-24041 : propagation schedule exists for QUEUE string and DESTINATION string
  • ora-13188 : cell decode failed
  • ora-12005 : may not schedule automatic refresh for times in the past
  • ora-12497 : maximum combined categories exceeds string
  • ora-12454 : label string does not exist for policy string
  • ora-30032 : the suspended (resumable) statement has timed out
  • ora-08264 : ora_addr: cannot close nameserver
  • ora-33998 : (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.
  • ora-06915 : CMX: unknown t_event in datarq
  • ora-19320 : Host name not specified in HTTP URL
  • ora-02256 : number of referencing columns must match referenced columns
  • ora-00208 : number of control file names exceeds limit of string
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-25100 : TABLESPACE option can only be used with ALTER INDEX REBUILD
  • ora-16537 : child count exceeded
  • ora-25470 : duplicate attribute value for variable: string
  • ora-29308 : view TS_PITR_CHECK failure
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-09888 : osnTXtt: txipc channel creation failed
  • ora-00133 : value of string is too long
  • ora-13040 : failed to subdivide tile
  • ora-39018 : master process received invalid message number string
  • ora-25102 : PARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-09352 : Windows 32-bit Two-Task driver unable to spawn new ORACLE task
  • ora-29302 : database is not open clone
  • ora-12351 : cannot create view using a remote object which has a remote object reference
  • ora-07589 : spdde: system ID not set
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-32338 : on commit refresh grab all the detailed tables
  • ora-31154 : invalid XML document
  • 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.