My Oracle Support Banner

ORA-27486: insufficient privileges Error While Executing Purge Script (Doc ID 2389073.1)

Last updated on FEBRUARY 07, 2024

Applies to:

Oracle Communications Unified Inventory Management - Version and later
Information in this document applies to any platform.


Customer using OOTB purging utility to purge the DISCONNECTED services from the UIM DB. Though the report is generated without any issue but deletion fails with following error:
/ execute -ed 04/04/2018 -status disconnected
Please enter DB Credentials:
Username : XXXX
Password :
Report Generated : ServicePurgeReport-04-11-18-14-41-14.txt
Warning: Records matching specified criteria will be permanently deleted.
  Please take backup before executing purge.
  The purge end date is within last 12 months.
Number of services to be purged : 1
Are you sure you want to continue with service purge? (Y|N) Y
Populating data to temporary table.
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 146
ORA-06512: at "SYS.DBMS_SCHEDULER", line 288


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.