ORA-14164: subpartition "string": INITRANS value must be
less than MAXTRANS value



ORA-14164: subpartition "string": INITRANS value must be less than MAXTRANS value..

Answer / guest

Cause: Value of INITRANS was found to be greater than that
of MAXTRANS for a subpartition whose name (explicitly
specified by the user) is displayed in this message. Note
that if INITRANS and/or MAXTRANS values for this
subpartition were not specified explicitly, default values
at partition-level would be used. If, in turn, default
INITRANS and/or MAXTRANS 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 value of INITRANS (whether specified
explicitly or derived from the default value at
partition-level, table-level or index-level) is no greater
than that of MAXTRANS

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22976: incorrect number of arguments to MAKE_REF

1 Answers  


LSX-00234: invalid decimal "~S"

1 Answers  


ORA-25102: PARALLEL option can only be used with ALTER INDEX REBUILD

1 Answers  


RMAN-10024: error setting up for rpc polling

1 Answers  


TNS-02508: Encryption: server negotiation response in error

1 Answers  






ORA-26076: cannot set or reset value after direct path structure is allocated

0 Answers  


ORA-13764: Value "string" is illegal as a result percentage.

1 Answers  


ORA-16729: Validating the value of property string hits error string.

1 Answers  


PCC-00011: Already in a declare section at line number in file string

1 Answers  


ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"

1 Answers  


ORA-09810: Unable to get process ID from connection

1 Answers  


ORA-30511: invalid DDL operation in system triggers

1 Answers  


Categories