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

NNO-00155: warning: hint number has missing address, hint ignored

1 Answers  


LPX-00250: invalid attribute declaration

1 Answers  


ORA-16748: Resource guard encountered errors during database open

1 Answers  


SQL*Loader-00286: ROWS parameter is not supported when loading an IOT.

1 Answers  


QSM-02161: see the reason why REFRESH_FAST_AFTER_ONETAB_DML is disabled

1 Answers  






PCC-01511: Identifier on line number in file string too long for code generated in file string

1 Answers  


PLS-00156: Null constraints not supported for object attributes.

1 Answers  


ORA-25230: invalid value string, WAIT should be non-negative

1 Answers  


IMP-00400: Warning: Object type "string"."string" already exists with a different typeid

1 Answers  


IMG-00720: image processing internal error

1 Answers  


NZE-28840: Wallet is already open.

1 Answers  


ORA-31058: cannot modify read-only XOBs

1 Answers  


Categories