Friday, 16 March 2012

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

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 or subpartitions, ALLOCATE STORAGE clause may be specified with ALTER TABLE MODIFY PARTITION or 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.

No comments:

Post a Comment