My Oracle Support Banner

Salesuploadpurge.Ksh Fails With An Error ‘Cannot Drop The Only Partition Of The Partition Table' (Doc ID 2425902.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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

Symptoms

While running the salesuploadpurge.ksh batch job using rmswrap_shell.ksh wrapper, the system is trying to delete the last existing partition and throwing a package error.

"0PACKAGE_ERROR@1ORA-14083: cannot drop the only partition of a partitioned table@2CORESVC_SALES_UPLOAD_SQL.PURGE_ARCHIVE
salesuploadpurge~20180507180303~PURGE_SVC_ARCHIVE~CORESVC_SALES_UPLOAD_SQL.PURGE_ARCHIVE Failed"

Steps To recreate:

1.Run salesuploadpurge.ksh.

2.Batch fails with error ‘cannot drop the only partition of the partition table.

 

Cause

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
Symptoms
Cause
Solution
References


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