Cleaning older snapshot data without increasing undo tablespace
Hi,
I have one database on which last three years snapshot accumulated which i want to delete. I do not having enough space so i can't allow to grow undo tablespace and i do not want to drop perfstat user and tablespace. is there any way through which i can drop all older snapshot data without increasing undo tablespace size.
Thanks and Regards,
Kets
I have one database on which last three years snapshot accumulated which i want to delete. I do not having enough space so i can't allow to grow undo tablespace and i do not want to drop perfstat user and tablespace. is there any way through which i can drop all older snapshot data without increasing undo tablespace size.
Thanks and Regards,
Kets
0