I had several snapshot sites refreshing from one master table.

I have shutdown and de-commisioned one snapshot database (without breaking the refresh jobs) and this has cause the snapshot log tables in the master site to grow.

I have tried to use dbms_snapshot.purge_log procedure to clean the snapshots logs but it does not clean it.

Dropping snapshots and recreating them on several sites is a pain.

Is there any other way to clean the snapshot logs ?
Why did purge_log procedure did not clean the snapshot log tables ?

Thx

- Jignesh