ORA-14185: incorrect physical attribute specified for this
index partition



ORA-14185: incorrect physical attribute specified for this index partition..

Answer / guest

Cause: unexpected option was encountered while parsing
physical attributes of a local index partition; valid
options for Range or Composite Range partitions are
INITRANS, MAXTRANS, TABLESPACE, STORAGE, PCTFREE, PCTUSED,
LOGGING and TABLESPACE; but only TABLESPACE may be specified
for Hash partitions STORE IN () is also disallowed for all
but Composite Range partitions

Action: remove invalid option(s) from the list of physical
attributes of an index partition

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23612: unable to find tablespace "string"

1 Answers  


QSM-00789: the string string is invalid for directive string

1 Answers  


RMAN-05021: this configuration cannot be changed for a BACKUP or STANDBY control file

1 Answers  


QSM-01078: materialized view, string, is marked invalid

1 Answers  


ORA-13643: The task can not be interrupted or cancelled.

1 Answers  


ORA-36666: (XSDPART04) workspace object is not a concat dimension.

1 Answers  


ORA-16232: adding Logical Standby skip entry for table string.string

1 Answers  


ORA-40223: data mining model import failed, job name=string, error=string

2 Answers  


PLS-01413: Use of NULL an expression

1 Answers  


ORA-40205: invalid setting name string

1 Answers  


ORA-13378: invalid index for element to be extracted

1 Answers  


NNL-01050: Version banner is "string"

1 Answers  


Categories