'ORA-20103: Data has conflict, please use a new dbid' When Importing AWR Data To The Same Database After 18c Upgrade
(Doc ID 2547548.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
- Trying to export AWR data and truncate wrh$ and wri$ tables before the upgrade and import it back post upgrade into same database to 18c database
- However import fails with following errors:
begin
*
ERROR at line 1:
ORA-20103: Data has conflict, please use a new dbid
to import or drop the local data first.
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 2837
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 2465
ORA-06512: at line 4
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 |