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

DRG-50915: last document number string is not an integer

1 Answers  


ORA-26024: SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable

0 Answers  


DGM-16909: Fatal error - quitting...

1 Answers  


ORA-39122: Unprivileged users may not perform string remappings.

1 Answers  


ORA-13760: duplicate entry for "SQL_ID" "string" in "SQL Tuning Set" "string"

1 Answers  


LFI-00120: Unable to parse root filename string.

1 Answers  


RMAN-04000: memory allocation failure

1 Answers  


DRG-11858: Gopher Server Replies

1 Answers  


ORA-01647: tablespace 'string' is read only, cannot allocate space in it

2 Answers  


ORA-19803: Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)

1 Answers  


PLS-00241: invalid external type specification for SQLSTATE

1 Answers  


ORA-08261: ora_addr: cannot find name in nameserver

1 Answers  


Categories