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-32731: Another Parallel Oradebug session is in progress

1 Answers  


ORA-12805: parallel query server died unexpectedly

1 Answers  


DBV-00200: Block, dba number, already marked corrupted

1 Answers  


ORA-13448: GeoRaster metadata BRS error

1 Answers  


RMAN-12017: could not locate pieces of backupset key string

1 Answers  






PCB-00308: FOR clause is an Oracle extension

1 Answers  


ORA-31518: change column string already exists in CDC change table string.string

1 Answers  


ORA-23336: priority group string does not exist

1 Answers  


ORA-00400: invalid release value string for parameter string

1 Answers  


ORA-19717: for non-OMF search the pattern must be specified

1 Answers  


CLSR-00512: Invalid CAA trigger event type [string]

1 Answers  


ORA-01912: ROW keyword expected

1 Answers  


Categories