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

ORA-15122: ASM file name 'string' contains an invalid file number

1 Answers  


ORA-01989: role 'string' not authorized by operating system

1 Answers  


ORA-06250: NETNTT: cannot allocate send and receive buffers

1 Answers  


RMAN-06084: the target database may not be mounted when issuing REPLICATE

1 Answers  


ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.

1 Answers  






ORA-13019: coordinates out of bounds

1 Answers  


SQL*Loader-00428: count for field string not stored in character or integer field

1 Answers  


NNO-00266: cannot find document "string" in configuration database

1 Answers  


ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value

1 Answers  


RMAN-06609: AS COPY can be configured only for disk device

1 Answers  


PLS-00580: supertype must be an object type

1 Answers  


ORA-07274: spdcr: access error, access to oracle denied.

2 Answers  


Categories