The generated AWR baselines cause the snapshots to be stored, so you will not be allowed to delete old snapshots.
Therefore, it is necessary to drop the existing baseline.
To query existing baselines;
|
1 |
SQL> select * from WRM$_BASELINE; |
To drop baseline;
|
1 |
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE ( baseline_name => 'AWR_1349955207167',cascade =>true,dbid=>697904151 ); |
