ORA-14195: ALLOCATE STORAGE may not be specified for RANGE
or LIST partitioned object



ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object..

Answer / guest

Cause: User specified ALLOCATE STORAGE clause in ALTER
TABLE/ALTER INDEX statement issued against a
range-partitioned index which is illegal.

Action: Remove the illegal option. If it is desired to add
storage to individual partitions, ALLOCATE STORAGE clause
may be specified with ALTER TABLE/INDEX MODIFY PARTITION
statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28866: Invalid peer certificate encoding

1 Answers  


SQL*Loader-00350: Syntax error at line number.

1 Answers  


ORA-16752: Resource guard could not mount standby

1 Answers  


LPX-00109: duplicate name "~S" in mixed-content declaration

1 Answers  


QSM-01016: Query rewrite does not support, aggregate, string

1 Answers  






NNC-00501: warning: "string" parameter value must be between number and number, setting to number

1 Answers  


ORA-31522: could not find Streams object string for CDC change set string

1 Answers  


ORA-16737: The log transport service for standby "string" has an error.

1 Answers  


TNS-01161: Spawn alias string was not found. Check listener parameter file

1 Answers  


ORA-12669: Shared server: outbound protocol does not support proxies

1 Answers  


NZE-29014: Maximum fragment length extension is incorrect.

1 Answers  


LPX-00203: could not read from "~s" (error ~u)

1 Answers  


Categories