Unable to drop an AWR baseline

From: Jithin Sarath <jithinsarath_at_gmail.com>
Date: Thu, 8 Dec 2016 23:36:08 +0530
Message-ID: <CACoevcrHWHCG=mUvxNm66JsbMMMap3zHXUaSP-U_LERk52tgtw_at_mail.gmail.com>

I have an AWR baseline someone created ages ago. As part of some house keeping we would like to delete it. But whatever I try it doesn't let itself be deleted :)

Any thoughts?

SQL> SELECT baseline_id, baseline_name, START_SNAP_ID,   2 TO_CHAR(start_snap_time, 'DD-MON-YYYY HH24:MI') AS start_snap_time,

  3         END_SNAP_ID,
  4         TO_CHAR(end_snap_time, 'DD-MON-YYYY HH24:MI') AS end_snap_time

  5 FROM dba_hist_baseline
  6 WHERE baseline_type = 'STATIC'
  7 ORDER BY baseline_id;

BASELINE_ID BASELINE_NAME                  START_SNAP_ID START_SNAP_TIME

END_SNAP_ID END_SNAP_TIME

----------- ------------------------------ ------------- -----------------
----------- -----------------
          1 AABB AWR NOV-DEC 2009 baseline         29953 08-NOV-2009 00:00
      30721 10-DEC-2009 00:00

SQL> BEGIN
  2 DBMS_WORKLOAD_REPOSITORY.drop_baseline(baseline_name => 'AABB AWR NOV-DEC 2009 baseline');
  3 END;
  4 /
BEGIN
*
ERROR at line 1:

ORA-13526: baseline (AABB AWR NOV-DEC 2009 baseline) does not exist
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 704
ORA-06512: at line 2

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 08 2016 - 19:06:08 CET