My Oracle Support Banner

SALPRG Batch Fails To Drop Last Partition From TRAN_DATA_HISTORY Table Which Meets The Purge Criteria (Doc ID 2358254.1)

Last updated on OCTOBER 15, 2020

Applies to:

Oracle Retail Merchandising System - Version 15.0.1 and later
Information in this document applies to any platform.


When SALPRG batch attempts to drop last partition of TRAN_DATA_HISTORY table which meets the purge criteria, it fails to drop the partition generating the following error:

Steps to reproduce:

  1. Make sure TRAN_DATA_HISTORY table is defined as interval range partition.
  2. Make sure the dates associated to that partition fall within the purge criteria for salprg.
  3. Make sure that you have only one partition for TRAN_DATA_HISTORY table
  4. Run salprg
  5. Notice the error message:
    salprg_1~20171218084019~process~TRAN_DATA_HISTORY~-14083~ORA-14083: cannot drop the only partition of a partitioned table~EXECUTE DYNAMIC STATEMENT ALTER TABLE RMS01.TRAN_DATA_HISTORY DROP PARTITION TRAN_DATA_HISTORY_P1 UPDATE INDEXES





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.