Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-11844: HTTP Version Not Supported

1 Answers  


ORA-13516: SWRF Operation failed: string

1 Answers  


RMAN-06173: no set newname command has been issued for datafile string when restore auxiliary

1 Answers  


ORA-22922: nonexistent LOB value

1 Answers  


ORA-24803: illegal parameter value in lob read function

1 Answers  






ORA-01334: invalid or missing logminer dictionary processes context

1 Answers  


ORA-06121: NETTCP: access failure

1 Answers  


QSM-00777: the specified directive string is unsupported at this time

1 Answers  


ORA-23534: missing column in materialized view container table "string"."string"

1 Answers  


PLS-00254: OUT and IN/OUT modes cannot be used in this context

1 Answers  


ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.

1 Answers  


NID-00452: Succesfully changed database ID.

1 Answers  






Categories