ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite)
Range or List partitioned table



ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table..

Answer / guest

Cause: User specified ALLOCATE STORAGE clause in ALTER TABLE
statement issued against a Range or Composite Range
partitioned table which is illegal.

Action: Remove the illegal option. If it is desired to add
storage to individual partitions/subpartitions, ALLOCATE
STORAGE clause may be specified with ALTER TABLE MODIFY
PARTITION/SUBPARTITION statement. If it is desired to add
storage to all subpartitions of a Composite partition,
ALLOCATE STORAGE clause may be specified with ALTER TABLE
MODIFY PARTITION.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-15094: attempted to write to file opened in read only mode

1 Answers  


ORA-31006: Path name segment length string exceeds maximum length string

1 Answers  


ORA-00291: numeric value required for PARALLEL option

1 Answers  


NZE-29176: CRL signature verification failed

1 Answers  


LPX-00302: Incorrect stylesheet. The node is not valid.

1 Answers  






ORA-32629: measure used for referencing cannot be updated

1 Answers  


ORA-30369: maximum number of columns is 32

1 Answers  


ORA-03235: max # extents (string) reached in table string.string subpartition string

1 Answers  


ORA-22331: cannot alter an incomplete type

1 Answers  


ORA-29555: Java source, class or resource is not allowed here

1 Answers  


RMAN-08533: restoring blocks of datafile string

1 Answers  


QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater

1 Answers  


Categories