My Oracle Support Banner

Datapatch Reports: Package Body created with compilation errors on RECLAIMTEMPSEGMENT and KCP_PLG_RECLAIM_SEGMENT (Doc ID 2687525.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Exadata Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.
Linux x86-64 on Oracle Public Cloud


1. After installing and running Datapatch reports errors attempting to rollback an old patch from PDB$SEED and other user PDBs:

Patch 28281213 rollback (pdb PDB$SEED): WITH ERRORS
  logfile: <PATH>>/cfgtoollogs/sqlpatch/28281213/22303559/28281213_rollback_DUMMY121_PDBSEED_2020Jun16_12_03_23.log (errors)
    Error at line 34: Warning: Package Body created with compilation errors.
    Error at line 40: 398/13   PLS-00323: subprogram or cursor 'RECLAIMTEMPSEGMENT' is declared
    Error at line 44: 671/13   PLS-00323: subprogram or cursor 'KCP_PLG_RECLAIM_SEGMENT' is

2. A query on  PDB_PLUG_IN_VIOLATIONS shows errors:

12-JUN-20 09.22.10,4 PDB$SEED SQL patch error ERROR 0 1 SQL patch ID/UID 28281213/22303559 (MERGE REQUEST ON TOP OF DATABASE BP FOR BUGS 19809171 2800 PENDING
Call datapatch to reinstall 63003  ROLLBACK with status WITH ERRORS in the PDB.

3. The error persists even if we recompile the objects.

4. Note that the patch that Datapatch is pointing was installed before in a previous installed




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.