Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-14178: STORE IN (DEFAULT) clause is not supported for
hash partitioned global indexes



ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes..

Answer / guest

Cause: STORE IN (DEFAULT) is valid only for local indexes.

Action: a) Specify a tablespace list in place of DEFAULT, or
b) Remove STORE IN clause and specify tablespaces
individually for each 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

EXP-00066: Object table string is missing its object identifier index

1 Answers  


LSX-00281: referenced ID "~S" is not defined

1 Answers  


ORA-12158: TNS:could not initialize parameter subsystem

1 Answers  


NNL-00814: Total query processing time: string

1 Answers  


ORA-36740: A CHILDLOCK was detected in your valueset

1 Answers  






ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

1 Answers  


ORA-22606: pickler image handle [string] is not well-formed

1 Answers  


ORA-38772: cannot add datafile 'string' - file could not be created

1 Answers  


NCR-04014: NCRR: Invalid instance name

1 Answers  


NID-00140: Specified database name string does not match previous name used string

1 Answers  


NZE-28872: Invalid peer certificate format

1 Answers  


NNL-00974: Name: string

1 Answers  






Categories