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


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-30182: invalid precision specifier

1 Answers  


NID-00354: Instance shut down

1 Answers  


ORA-14625: subpartition contains rows corresponding to values being dropped

1 Answers  


TNS-00284: Imm Max Avg Bytes/Sec : number

1 Answers  


ORA-24159: invalid variable definiton

1 Answers  






RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


ORA-36874: (XSFTDSC04) Expression string cannot be used to define a column in a LIMITMAP.

1 Answers  


DRG-50803: failed to define output

1 Answers  


ORA-39150: bad flashback time

1 Answers  


NZE-28868: Peer certificate chain check failed.

0 Answers  


ORA-25232: duplicate recipients specified for message

1 Answers  


RMAN-06484: changed controlfile copy expired

1 Answers  






Categories