Re: Archiving data into another database
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 31 Jan 2007 14:00:30 -0800
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 **
--
//www.freelists.org/webpage/oracle-l
Other related posts:
