ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite)
Range or List partitioned table
- 1 Answers
- 3514 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 |
NNO-00617: enabling AUTHORITY-REQUIRED on system queries
PLS-00920: parameter plsql_native_library_dir is not set
ORA-06737: TLI Driver: connection failed
NID-00507: APPEND Append to output log NO
ORA-07200: slsid: oracle_sid not set.
ORA-24149: invalid rule name
ORA-16234: restarting to reset Logical Standby apply
ORA-09978: skxfqhdel: Error Disconnecting from another endpoint.
LFI-00006: Invalid parameter to function string.
AMD-00100: not found: string "string"
ORA-29355: NULL or invalid string argument specified
PLS-00260: Datetime/Interval constraints must be in range (0 .. 9)
Oracle Errors 
