View Single Post
  #2 (permalink)  
Old October 15th, 2007, 03:53
chrisplough's Avatar
chrisplough chrisplough is offline
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 821
Blog Entries: 7
Thanks: 53
Thanked 200 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
Re: Exceptions during Purge

Ajoy,

The first and second errors appear to be VPD related, meaning that the user doesn't appear to have privileges to modify or delete some records. The third error is common with the purge scripts - which don't automatically resolve data dependency issues such as the outstanding tender. The fourth error is also fairly common.

There are some very experienced OTM DB experts on the forums who have developed their own data purge scripts, based on the initial scripts provided by G-Log / Oracle. Unfortunately, these provided scripts are not what I'd consider fully-functional and need to be adjusted towards your needs. If others are willing to share, perhaps we can develop a more functional set of data purge scripts for the community.

Can anyone offer more detailed advice?

Thanks,
Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Reply With Quote