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

LSX-00133: attribute "use" has invalid value "~S"

1 Answers  


ORA-12590: TNS:no I/O buffer

1 Answers  


DRG-11113: value of string must be one of string

1 Answers  


ORA-01633: Real Application Clusters Option needed for this operation

1 Answers  


ORA-03236: max # extents (string) reached in index string.string subpartition string

1 Answers  






TNS-01420: Presentation: string

1 Answers  


TNS-00122: Missing ADDRESS(es) in TNSNET.ORA file

1 Answers  


ORA-25965: fact table must be included in the from clause

1 Answers  


ORA-01550: cannot drop system tablespace

1 Answers  


ORA-30740: cannot grant UNDER privilege on this object

1 Answers  


ORA-25953: join index cannot be a functional index

1 Answers  


ORA-16529: bad sender id

1 Answers  


Categories