Need suggestion for this scenario
Date: 27 Jun 2001 13:47:16 -0700
Message-ID: <7728d0ac.0106271247.4f297d8b_at_posting.google.com>
Hi all,
I have the following scenaria... I need the suggestions for this...
I have some views in the remote oracle server(8i).
What I have to do is, I have to create a new database
in my local machine which will be a replica of the
views in that remote database.
The remote server is the live server. All the
transaction will be in that remote server. For some
other application we need all the datas from that live
server to our local database.
And once I set up the local database, I need to get in
sync with the remote server (I have to update my local
database with the remote server's datas) may be once
in two days or so...
Here is my question.
What will be the best way to handle this.
I thought of creating some triggers which will insert
the newly entered records and the updated records into
a new table. Then I can export those tables and import
into my local database. Is this a good idea or not!
Need your suggestion on this... And also can you guys suggest me a
better way to do this...
Thanks in advance...
Regards,