HSTPRG Batch Fails To Drop The Last Partition From DAILY_SALES_DISCOUNT Table Which Meet The Purge Criteria

(Doc ID 2349142.1)

Last updated on JANUARY 22, 2018

Applies to:

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

Symptoms

When HSTPRG batch attempts to drop the last partition from DAILY_SALES_DISCOUNT table, it fails to drop the partition with error:



Steps to Reproduce:

  1. Make sure DAILY_SALES_DISCOUNT is an interval range partition.
  2. Make sure the dates associated to that partition fall within the purge criteria for HSTPRG batch.
  3. Make sure that you have only one partition for DAILY_SALES_DISCOUNT
  4. Run HSTPRG.
  5. Notice the error message:
    hstprg_1~20170920012343~purge_discount_hist~DAILY_SALES_DISCOUNT~-14083~ORA-14083: cannot drop the only partition of a partitioned table~EXECUTE DYNAMIC STATEMENT ALTER TABLE RMS01.DAILY_SALES_DISCOUNT DROP PARTITION DAILY_SALES_DISCOUNT_P1 UPDATE INDEXES

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms