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 : 24-05-2017

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-12656 : Cryptographic checksum mismatch
  • ora-14297 : Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-09290 : sksaalo: error allocating memory for archival
  • ora-13011 : value is out of range
  • ora-01313 : LogMiner dictionary column type different from specified type
  • ora-32168 : Cannot perform operation on a null AnyData
  • ora-16246 : User initiated abort apply successfully completed
  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-01584 : unable to get file size of control file to be backed up
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-29882 : insufficient privileges to execute indextype
  • ora-23358 : invalid remote user
  • ora-08274 : Out of memory for environment variable
  • ora-28103 : adding a policy to an object owned by SYS is not allowed
  • ora-24089 : AQ Agent string already exists
  • ora-24338 : statement handle not executed
  • ora-24394 : invalid mode for destroying connection pool
  • ora-26018 : Column string in table string does not exist
  • ora-29931 : specified association does not exist
  • ora-36634 : (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-28654 : table and partition not overflow compatible
  • ora-22321 : method does not return any result
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-34296 : (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).
  • ora-09798 : Label comparison failed.
  • ora-29819 : cannot associate default values with columns
  • 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.