Re: Archiving data into another database

From: Murtuja Khokhar <murtuja_oracle@xxxxxxxxx>
To: lucdemanche@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 30 Jan 2007 21:53:39 -0800 (PST)

For Purging ,You may have these two alternatives.
   
  1 Write a procedure which selects data from Production DB and inserts in 
Purge DB then delete that data from Production DB.
   
  You can set job for this procedure to run in off peak hours so it will not 
effect the performance.
   
  2. Take export from Production DB and import it into Purge DB then delete 
that data from Production DB.

  
Luc Demanche <lucdemanche@xxxxxxxxx> wrote:
    Hi,
   
  We are thinking to have a process that will archive data from our production 
database to another database, or somewhere else .....
  For example, data of an old customer, info of an old product, etc ....
   
  Do you have some ideas, some experiences that you would like to share with us 
?
   
  Thanks you
  Luc

-- 
Luc Demanche
Oracle DBA
(514) 867-9977 


         
---------------------------------
Looking for earth-friendly autos? 
 Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

References:

Archiving data into another database
From: Luc Demanche

Re: Archiving data into another database

Other related posts: