ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite)
Range or List partitioned table
- 1 Answers
- 3818 Views
- I also Faced
- E-Mail Answers
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 |
LFI-00147: File string.string does not exist
PLW-05001: previous use of 'string' (at line string) conflicts with this use
KUP-04008: access to file denied
ORA-30388: name of the rewrite equivalence is not specified
ORA-38449: table "string" does not exist or is not accessible
ORA-38418: ADT associated with the attribute set string does not exist
ORA-38436: attribute set used for an Expression set may not be modified.
ORA-21612: key is already being used
PCC-02323: found typedef name used in an expression (expecting a value)
ORA-25439: duplicate variable value for variable: string
ORA-29397: cannot grant/revoke switch privilege for string
ORA-15179: missing or invalid alias name
Oracle Errors 
