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-13601: The specified Advisor string does not exist.

1 Answers  


PCC-02390: No EXEC SQL CONTEXT USE statement encountered

1 Answers  


NNL-00238: Statistic counter reset interval is now string

1 Answers  


ORA-28173: certificate not provided by proxy

1 Answers  


NNL-00285: Server has no queued system queries

1 Answers  


ORA-39305: specified schema "string" does not exist

1 Answers  


KUP-04004: error while reading file string

1 Answers  


ORA-12622: TNS:event notifications are not homogeneous

1 Answers  


ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string

1 Answers  


ORA-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.

1 Answers  


ORA-01867: the interval is invalid

1 Answers  


CLSR-00526: Failed to retrieve database configuration in OCR

1 Answers  


Categories