Discussions
ORA-00001: unique constraint (ORA-00001: unique constraint (SYS.WRM$_SNAPSHOT_PK)
Hello
We face this error in production DB 19C
+++++++
SQL> exec dbms_workload_repository.create_snapshot
BEGIN dbms_workload_repository.create_snapshot; END;
*
ERROR at line 1:
ORA-13509: error encountered during updates to a AWR table
ORA-00001: unique constraint (ORA-00001: unique constraint
(SYS.WRM$_SNAPSHOT_PK) violated
.) violated
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 145
ORA-06512: at line 1
+++++++
Any idea will be really appreciated.
Regards,
Alexander
0