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-06-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-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-16114 : applying DDL transaction with commit SCN string
  • ora-36389 : (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-30576 : ConText Option dictionary loading error
  • ora-06529 : Version mismatch - PL/SQL profiler
  • ora-02852 : Invalid critical-section time out value
  • ora-26057 : Conversion is not necessary for this direct path stream.
  • ora-31217 : DBMS_LDAP: PL/SQL - Invalid LDAP newparent.
  • ora-36904 : (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.
  • ora-29337 : tablespace 'string' has a non-standard block size (string)
  • ora-12663 : Services required by client not available on the server
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-00017 : session requested to set trace event
  • ora-01166 : file number string is larger than string (string)
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-16170 : Terminal recovery may have left the database in an inconsistent state
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-03237 : Initial Extent of specified size cannot be allocated in tablespace (string)
  • ora-39776 : fatal Direct Path API error loading table string
  • ora-29952 : cannot issue DDL on a domain index partition marked as LOADING
  • ora-06778 : TLI Driver: error sending ccode
  • ora-39710 : only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
  • ora-12534 : TNS:operation not supported
  • ora-06709 : TLI Driver: message send failure
  • ora-16217 : prepare to switchover has not completed
  • ora-12712 : new character set must be a superset of old character set
  • 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.