ORA-14191: ALLOCATE STORAGE may not be specified for
Composite Range partitioned object



ORA-14191: ALLOCATE STORAGE may not be specified for Composite Range 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

ORA-16593: XML conversion failed

1 Answers  


SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause specified for nested table column string

1 Answers  


PLS-00382: expression is of wrong type

1 Answers  


PLW-05005: function string returns without value at line string

1 Answers  


RMAN-08512: waiting for snapshot controlfile enqueue

1 Answers  






ORA-04063: %s has errors

1 Answers  


ORA-13701: Snapshot pair [string, string] seems to be specified in reverse order.

1 Answers  


ORA-00448: normal completion of background process

1 Answers  


ORA-22323: error table "string"."string" does not exist

1 Answers  


ORA-03202: the scan limit specification is invalid

1 Answers  


IMG-00553: invalid rotate value

1 Answers  


ORA-29909: label for the ancillary operator is not a literal number

1 Answers  


Categories