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

QSM-00501: unable to initialize Summary Advisor environment

1 Answers  


NNL-00972: Query next issued in: string

1 Answers  


TNS-00248: Unable to get information from file :string: Exiting with NR error:number

1 Answers  


ORA-06745: TLI Driver: listener already running

1 Answers  


ORA-19203: Error occurred in DBMS_XMLGEN processingstring

1 Answers  






ORA-19909: datafile string belongs to an orphan incarnation

2 Answers  


ORA-12551: TNS:missing keyword

1 Answers  


ORA-19667: cannot do incremental restore of datafile string

1 Answers  


NNO-00633: detected fatal delegation loop involving server "string"

1 Answers  


PROC-00009: Cannot perform cluster registry operation because the buffer passed is too small.

1 Answers  


ORA-03286: ALLOCATE EXTENT not valid for HASH CLUSTERS

1 Answers  


ORA-01903: EVENTS keyword expected

1 Answers  


Categories