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