<![CDATA[Hexagon Safety & Infrastructure - Post to topic Removing old data on a regular basis]]> http://support.hexagonsafetyinfrastructure.com/infocenter/index?page=home Post to topic Removing old data on a regular basis en Copyright © 2002, 2012, Oracle and/or its affiliates. All rights reserved. Oracle Knowledge Information Manager http://blogs.law.harvard.edu/tech/rss <![CDATA[Removing old data on a regular basis]]> We are looking to remove old outage events on a regular basis (whether that is monthly or yearly we aren't sure yet) but I was wondering what other companies have done and if there are any recommendations on what to tables to delete from.  Has anyone had any burnt fingers that would be helpful?  We are currently on the 9.2 database scheme.

Thanks in advanced.  

]]> 2016-09-16 15:38:00 Etc/GMT <![CDATA[RE: Removing old data on a regular basis]]> We are a 9-1-1 agency and not a utility so it may be somewhat different, but we use the Intergraph DBCopy program in IBackup with the Purge command.  The Purge section lists the tables to purge and we set it for 90 days. Everything is already backed up to the Archive server using the same program, so nothing is lost and we are able to run reports and search for past events.

]]> 2016-09-16 15:52:08 Etc/GMT