My Oracle Support Banner

Import for Replay getting Ora-20222: Capture's AWR Already Exists Cannot Import Again (Doc ID 887394.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.


The Database, through Enterprise Manager, is getting the following errors:

Request Start Date Sep 12, 2009 10:23:41 PM +00:00
Actual Start Date Sep 12, 2009 10:23:41 PM +00:00
Error # 20222
Run Duration (minutes) 0.0
CPU Used (seconds) 0.0
Instance ID 1
Session ID 1837,3647
Process ID 7710

Details ORA-20222: Capture's AWR already exists in the current database. Cannot
import again! ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 1506 ORA-06512:
at line 1

This error happened in EM (Enterprise Manager) when trying to replay a workload on the database copy after an upgrade to  When trying to create the Compare Report, EM requested for the import of the Capture AWR.  The first import of this Capture AWR failed because the tablespace ran out of space.  After fixing that problem, when trying to re-run the import you get the above error.


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.