Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_workload_repository.drop_snapshot_range doesn't work?

481897Oct 28 2008 — edited Jun 20 2012

My database 10.2.0.3 on Unix.
I want to drop those snap shots and do character set migration. This is what I did:
SQL> select snap_id from dba_hist_snapshot order by snap_id;

7619
7620
7621
7622
7623
7624
7625
7626
7627
7628
7629
7630
7631

13 rows selected.
SQL> execute dbms_workload_repository.drop_snapshot_range(7619,7631,3531915968);

PL/SQL procedure successfully completed.

SQL> select snap_id from dba_hist_snapshot order by snap_id;

7619
7620
7621
7622
7623
7624
7625
7626
7627
7628
7629
7630
7631

13 rows selected.

SQL>
Why the snap shot are still there?

Thanks for any help

Edited by: user478894 on Oct 28, 2008 9:32 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2012

Added on Oct 28 2008

#general-database-discussions

11 comments

4,205 views