ORA-14163: subpartition number string: INITRANS value must
be less than MAXTRANS value



ORA-14163: subpartition number 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 number (subpartitions
are numbered starting with 1) 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-22057: bad integer length [string]

1 Answers  


AMD-00145: error attaching Workspace "string" in mode "string"

1 Answers  


ORA-01292: no log file has been specified for the current LogMiner session

2 Answers  


LPX-00014: context is not clean

1 Answers  


ORA-38501: sub-query not allowed in the expression

1 Answers  






TNS-12649: Unknown encryption or data integrity algorithm

1 Answers  


ORA-16546: missing or invalid piece

1 Answers  


IMP-00088: Problem importing metadata for index string. Index creation will be skipped

1 Answers  


IMP-00077: Could not convert to server national character set's handle

1 Answers  


NID-00372: Change database ID and database name string to string? (Y/[N]) =>

1 Answers  


TNS-01067: Service display mode is string

1 Answers  


IMP-00042: CHARSET used, but the export file has specific character set

1 Answers  


Categories