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-01280: Fatal LogMiner Error.

1 Answers  


ORA-02726: osnpop: access error on oracle executable

1 Answers  


ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

1 Answers  


ORA-06441: ssvwatev: Incorrect parameter passed to function call

1 Answers  


ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

1 Answers  






ORA-29300: ORACLE error, tablespace point-in-time recovery

1 Answers  


ORA-30432: summary 'string.string' is in INVALID state

1 Answers  


ORA-30951: Element or attribute at Xpath string exceeds maximum length

1 Answers  


SQL*Loader-00257: TERMINATED BY EOF option not valid with ENCLOSED BY option

1 Answers  


PCC-02446: FOR clause not allowed in a DEALLOCATE statement

1 Answers  


TNS-00515: Connect failed because target host or object does not exist

1 Answers  


ORA-12633: No shared authentication services

1 Answers  


Categories