hi guys ,
need advise on the following:
we have 2 databases db1 and db2 ,we export data from db1 to db2 every day.we use db2 for reporting pupose.
Now due to various constraints we are planning to truncate data in db1 but we would like to keep the truncated data in db2 and do the updates everyday.(this will be come historical data)
What is the best way to achieve this. We use 9i release 2 on unix.
any advise is much appreciated