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 : 22-07-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-36885 : (XSSRF04) Error rewriting OLAP DML expression. Column name too big
  • ora-07280 : slsget: unable to get process information.
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-39000 : bad dump file specification
  • ora-06540 : PL/SQL: compilation error
  • ora-10572 : Test recovery canceled due to errors
  • ora-14500 : LOCAL option not valid without partition name
  • ora-14006 : invalid partition name
  • ora-16597 : Data Guard broker detects two or more primary databases
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-06606 : LU6.2 Driver: Unexpected response from SNA
  • ora-12216 : TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA
  • ora-19045 : character set id specified for XMLSerialize not valid
  • ora-30942 : XML Schema Evolution error for schema 'string' table string column 'string'
  • ora-06579 : Bind variable not big enough to hold the output value
  • ora-34143 : (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
  • ora-28290 : Multiple entries found for the same Kerberos Principal Name
  • ora-13154 : invalid precision specified
  • ora-06017 : NETASY: message receive failure
  • ora-00060 : deadlock detected while waiting for resource
  • ora-37039 : (XSMLTDCL05) You cannot maintain triggers in analytic workspace string because it is attached in MULTI mode.
  • ora-37073 : (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
  • ora-13622 : invalid recommendation annotation
  • ora-29300 : ORACLE error, tablespace point-in-time recovery
  • ora-38794 : Flashback target time not in current incarnation
  • ora-25239 : message ID not supplied when dequeuing from exception queue string.string
  • ora-32310 : object materialized views must select from an object table
  • ora-24144 : rules engine internal error, arguments: [string], [string]
  • ora-07252 : spcre: semget error, could not allocate semaphores.
  • ora-01784 : RECOVERABLE cannot be specified with database media recovery disabled
  • 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.