ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

Cause : teh usmo fP CUTSDE nadP CFTREE ofra usbaprittoinw hsoen ubme r(usbaprittoin saer unmebrde tsatrign iwt h1 )i sdsipalyde ni hti smsesgaee xecesd 010 .Ntoet hta fi CPTSUE Dadn/ro CPTRFE Evlause ofrt hsi usbaprittoinw eer onts pceiife depxlciilty ,dfealutv aule sa tprattiino-elvle owudl eb sue.d fI,i nt unr,d eafutl CPTSUE Dadn/ro CPTRFE Evlause ta aprittoinl-eevlw eer onts pceiife,d edfual tvlause ofrt h eprattiinoe dtbal eo ridne xwuol db euesd .I ftohs evlause ewr easlon o tsepcfiide xepilctil,y yssetmd eafutlsw oludb eu sde.

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

esnuer hta tas u mo fPTCUESDa n dPTCFEREf o rteh usbaprittoind ose onte xece d100

update : 27-04-2017
ORA-14161

ORA-14161 - subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100
ORA-14161 - subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

  • ora-40204 : model string already exists
  • ora-13484 : the file format and/or compression type is not supported
  • ora-13337 : failure in concatenating LRS polygons
  • ora-38732 : Expected file size string does not match string.
  • ora-19662 : archived log thread string sequence string could not be verified
  • ora-02156 : invalid TEMPORARY tablespace identifier
  • ora-01089 : immediate shutdown in progress - no operations are permitted
  • ora-26717 : SCN limit reached
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • ora-15073 : diskgroup string is mounted by another ASM instance
  • ora-29500 : NAMED keyword is invalid in CREATE JAVA CLASS
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-23336 : priority group string does not exist
  • ora-12987 : cannot combine drop column with other operations
  • ora-12542 : TNS:address already in use
  • ora-06042 : NETDNT: message receive failure
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-28006 : conflicting values for parameters string and string
  • ora-02241 : must of form EXTENTS (FILE BLOCK SIZE , ...)
  • ora-38470 : cannot revoke a privilege that was not granted.
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-38459 : XML Tag "string" not found for the XMLType attribute "string"
  • ora-19100 : PASSING or RETURNING keyword expected
  • ora-36676 : (XSDPART14) Missing dimension list for string.
  • ora-04003 : sequence parameter string exceeds maximum size allowed (string digits)
  • ora-19237 : XP0017 - unable to resolve call to function - string:string
  • ora-07475 : slsget: cannot get vm statistics.
  • ora-26089 : LONG column "string" must be specified last
  • ora-38758 : cannot flashback data file string; restored since last recovery
  • 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.