ORA-14317: cannot drop the last value of partition



ORA-14317: cannot drop the last value of partition..

Answer / guest

Cause: ALTER TABLE DROP VALUES tried to drop the last value
of the partition

Action: Cannot execute the command, unless two or more
values exist for partition

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30087: Adding two datetime values is not allowed

1 Answers   Oracle,


ORA-13222: failed to compute supercell for geometry in string

1 Answers  


ORA-29518: name string resolved to an object in schema string that is not a Java class

1 Answers  


ORA-28539: gateway does not support result sets

1 Answers  


QSM-01095: no suitable grouping_id found in MV with grouping sets

1 Answers  






ORA-16159: Cannot change protected standby destination attributes

1 Answers  


SQL*Loader-00563: bad length for VAR record

1 Answers  


ORA-07715: sksadtd: could not dismount archival device (SYS$DISMNT failure)

1 Answers  


ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table

1 Answers  


ORA-25468: column name not specified for alias: string

1 Answers  


RMAN-06026: some targets not found - aborting restore

1 Answers  


DRG-13305: 'off' attribute value must be in the range string..string, at line string

1 Answers  


Categories