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-01520: number of data files to add (string) exceeds limit of string

1 Answers  


ORA-13349: polygon boundary crosses itself

1 Answers  


ORA-12043: invalid CREATE MATERIALIZED VIEW option

1 Answers  


ORA-39079: unable to enqueue message string

1 Answers  


ORA-02020: too many database links in use

2 Answers  






RMAN-08006: database registered in recovery catalog

1 Answers  


ORA-12655: Password check failed

1 Answers  


ORA-15023: reached maximum allowable number of disks string

1 Answers  


NZE-28801: invalid object type

1 Answers  


NZE-28861: SSL connection would block

1 Answers  


ORA-02315: incorrect number of arguments for default constructor

1 Answers  


ORA-40215: model string is incompatible with current operation

1 Answers  


Categories