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-15029: disk 'string' is already mounted by this instance

1 Answers  


NZE-29231: the cryptographic engine failed to initialize

1 Answers  


ORA-01649: operation not allowed with a backup controlfile

1 Answers  


TNS-00298: Request to Navigator: string

1 Answers  


PLS-00703: multiple instances of named argument in list

1 Answers  






ORA-23292: The constraint does not exist

1 Answers  


TNS-01093: %s * string * number

1 Answers  


ORA-01272: REUSE only allowed when a file name is provided.

1 Answers  


ORA-30035: Undo tablespace cannot be specified as default temporary tablespace

1 Answers  


ORA-06777: TLI Driver: error reading parms

1 Answers  


TNS-12606: TNS: Application timeout occurred

1 Answers  


SQL*Loader-00954: Error shipping index to read buffer across 2-task

1 Answers  


Categories