Wednesday 14 March 2012

ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

Cause: User specified ALLOCATE STORAGE clause in ALTER TABLE statement issued against a partitioned table 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 MODIFY PARTITION statement.

No comments:

Post a Comment