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 : 26-09-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-24181 : The type string does not exist
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-39306 : schema name mismatch expected "string" got "string"
  • ora-32510 : cannot create watchpoint on unreadable memory
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • ora-06408 : NETCMN: incorrect message format
  • ora-32824 : schedule exists for source string and destination string
  • ora-29894 : base or varray datatype does not exist
  • ora-02467 : Column referenced in expression not found in cluster definition
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-00445 : background process "string" did not start after string seconds
  • ora-00823 : Specified value of sga_target greater than sga_max_size
  • ora-01693 : max # extents (string) reached in lob segment string.string
  • ora-22055 : unknown sign flag value [string]
  • ora-15107 : missing or invalid ASM disk name
  • ora-13236 : internal error in R-tree processing: [string]
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-30567 : name already used by an existing log group
  • ora-36722 : (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.
  • ora-23393 : the user is already the propagator
  • ora-23372 : type string in table string is unsupported
  • ora-31028 : Resource metadata length string exceeded maximum length string
  • ora-30150 : Invalid argument passed to OCIFile function
  • ora-37014 : (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.
  • ora-01662 : tablespace 'string' is non-empty and cannot be made temporary
  • ora-32604 : invalid REBUILD option
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-29541 : class string.string could not be resolved
  • ora-18004 : outline already exists
  • 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.