ORA-14162: subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100

Cause : teh usmo fP CUTSDE nadP CFTREE ofra usbaprittoinw hsoen aem e(xlpiictyl pseicfeidb yt h euesr )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 : 23-06-2017
ORA-14162

ORA-14162 - subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
ORA-14162 - subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100

  • ora-24460 : Native Net Internal Error
  • ora-36887 : (XSSRF06) Error rewriting OLAP DML expression. Column name string is not a valid ADT column.
  • ora-30030 : suppress resumable related error message
  • ora-26738 : %s 'string' is not empty
  • ora-26082 : load of overlapping segments on table string.string is not allowed
  • ora-01269 : Destination parameter string is too long
  • ora-30732 : table contains no user-visible columns
  • ora-07230 : slemcr: fopen error, unable to open error file.
  • ora-31403 : change table string already contains a column string
  • ora-39121 : Table string can't be replaced, data will be skipped. Failing error is: string
  • ora-00473 : ARCH process terminated with error
  • ora-36258 : (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.
  • ora-38735 : Wrong log number string in flashback log file header.
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-16625 : cannot reach the database
  • ora-08435 : PICTURE MASK missing the leading sign when SIGN IS LEADING specified
  • ora-32808 : message system link string does not exist
  • ora-25457 : evaluation function string returns failure
  • ora-01043 : user side memory corruption [string], [string], [string], [string]
  • ora-13833 : SQL profile named string doesn't exist
  • ora-38737 : Expected sequence number string doesn't match string
  • ora-22812 : cannot reference nested table column's storage table
  • ora-02278 : duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
  • ora-30400 : identical JOIN KEY clauses
  • ora-14622 : Value string already exists in subpartition string
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-26665 : STREAMS process string already exists
  • ora-01192 : must have at least one enabled thread
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-38460 : filtering based on datatype "string" not supported for XML Tags
  • 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.