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

TNS-00120: Missing PUMPS in INTCHG.ORA

1 Answers  


DRG-11834: Unsupported Media Type

1 Answers  


ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified

1 Answers  


NID-00105: Need to specify "LOGFILE=<logfile>" when using APPEND=YES option

1 Answers  


TNS-12612: TNS:connection is busy

1 Answers  






ORA-37113: OLAP API initialization error: (string)

1 Answers  


ORA-07569: slspool: $CLOSE failure

1 Answers  


ORA-28037: Cannot Get Session Key for RACF Authentication

1 Answers  


TNS-00092: * CMANAGER (or intlsnr) - will ask the Cmanager only

1 Answers  


ORA-31663: metadata remap name can not be defaulted

1 Answers  


QSM-01028: materialized view, string, is currently being refreshed

1 Answers  


TNS-04066: The following log events can be enabled or disabled:

1 Answers  






Categories