ORA-14162: subpartition "string": sum of PCTUSED and PCTFREE
may not exceed 100
- 1 Answers
- 34680 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: the sum of PCTUSED and PCTFREE for a subpartition
whose name (explicitly specified by the user) is displayed
in this message exceeds 100. Note that if PCTUSED and/or
PCTFREE values for this subpartition were not specified
explicitly, default values at partition-level would be used.
If, in turn, default PCTUSED and/or PCTFREE values at
partition-level were not specified, default values for the
partitioned table or index would be used. If those values
were also not specified explicitly, system defaults would be
used.
Action: ensure that a sum of PCTUSED and PCTFREE for the
subpartition does not exceed 100
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-02820: Unable to write the requested number of blocks
ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-32407: cannot exclude new values when materialized view log includes new values
ORA-19571: %s recid string stamp string not found in controlfile
ORA-31640: unable to open dump file "string" for read
ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
RMAN-08517: backup piece handle=string recid=string stamp=string
ORA-28045: SSL authentication between database and OID failed
SQL-02101: Inconsistent cursor cache. Unit cursor/global cursor mismatch
ORA-09209: sftget: error reading from file
ORA-02377: invalid resource limit
ORA-28151: more than one user name specified for command
Oracle Errors 
