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

DRG-13103: index table string is partitioned

1 Answers  


TNS-00139: Internal - Data passed from the Interchange listener is poorly formed

1 Answers  


NNO-00258: cannot load configuration from configuration database

1 Answers  


ORA-22809: nonexistent attribute

1 Answers  


ORA-09938: Save of signal handlers failed.

1 Answers  


ORA-30131: number of keys being set exceeds allocation

1 Answers  


ORA-12040: master rollback segment option not support by master site string

1 Answers  


ORA-12046: cannot use trusted constraints for refreshing remote MV

1 Answers  


ORA-19854: error obtaining connect string from target

1 Answers  


PROC-00028: Oracle Cluster Registry already in current version

1 Answers  


ORA-23379: connection qualifier "string" is too long

1 Answers  


PCC-00037: Unable to log on to ORACLE with "string". ORACLE error number: number

1 Answers  


Categories