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

PROT-00016: Internal Error

1 Answers  


ORA-23477: unable to alter propagation mode for object group "string"."string"

1 Answers  


ORA-02180: invalid option for CREATE TABLESPACE

1 Answers   IBM,


ORA-14322: DEFAULT partition already exists

1 Answers  


ORA-35078: (QFHEAD05) An EIF extension file header for string is not in the correct format.

1 Answers  






ORA-24381: error(s) in array DML

1 Answers  


ORA-01317: Not attached to a Logminer session

1 Answers  


ORA-30340: illegal dimension name

1 Answers  


TNS-00247: Unable to allocate memory for configuration data from TNSNET.ORA file

1 Answers  


ORA-15052: ASM file name 'string' is not in diskgroup "string"

1 Answers  


SQL*Loader-00807: error loading table

1 Answers  


RMAN-08161: contents of Memory Script:

1 Answers  


Categories