SQL Performance (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center