'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 JANUARY 08, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
- 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:
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
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