Executing DROP_SNAPSHOT_RANGE Encounter ORA-00942 ORA-06512 (Doc ID 2712526.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

•  19.6.0.0.0 version
• AWR SNAPSHOT data cannot been auto purged ，manual execute DROP_SNAPSHOT_RANGE encounter following error:
    
  SQL> select max(snap_id),min(snap_id) from WRM$_SNAPSHOT;

  MAX(SNAP_ID) MIN(SNAP_ID)
  ------------ ------------
  2373 1
  SQL> exec DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE(1,2373);
  BEGIN DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE(1,2373); END;

  *
  ERROR at line 1:
  ORA-13509: error encountered during updates to a AWR table
  ORA-00942: table or view does not exist
  ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 193
  ORA-06512: at line 1

   

Changes

 19c database.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.