Beginners question on table replication/backup

I have a business problem which requires an Oracle database to be operated from three different ofices as part of a round-the-clock business process.

Thus, this application has to run from 0h-->8h in London, 8h-->16h in New York and finally 16h-->24h in Tokyo.

The application database requires a number of daily and weekly transaction tables which have to be emptied at the end of their time cycle, with updates to various time lined based summary tables.

Is there anyway of avoiding an 'end of day' or 'end of week' batch process which would handle the empty table update master table process? Data is being fed into these transaction tables all day, sometimes at high volumes. Received on Thu Apr 15 1999 - 01:24:59 CDT