Re: Archiving data into another database

Just to let you know that there are commercial strength Archiving applications out there. This is normal practice on many Oracle EBS (Apps) environments where data growth is measured in tens or even hundreds of Gigs per month. HP RIM (previously OuterBay), Princeton Softech Archiving, Applimation, etc. provide such applications, primarily for Oracle EBS but now expanded to cover other apps.

The basic concept is this: Use application-provided purge routines to identify and stage data to be purged to a temporary area, write it out to another schema (on a different database or on the same database), and then delete the identified data. Provide a "unified" view by creating views that UNION ALL the active and archived table via a DB link. Applications do not have to change much (at least on Oracle Apps, it doesn't change at all - access is manipulated using Responsibilities attached to the right 'archive data set').

Fyi, these packages are not cheap, but if they do the job, esp on Oracle Apps databases.

-- 
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l