-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|