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.
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
Steps To recreate:
2.Batch fails with error ‘cannot drop the only partition of the partition table.
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