Re: OK - Looking for the big Oracle guru brains

On Tue, 28 Aug 2001 20:56:18 GMT, Scorpion <bognbac_at_yahoo.com> wrote:
>without using export/import and RMAN, see if you can do this!
>
>I have a customer that I need to get 15 tables from. These range from
>200 rows to 16 million. There can be no db link etc but I need to get
>the data from them and then do a nightly update of the changed data
>--- not the whole table, just the changed data.
>
>Any brainy ideas?
>
>Thanks ahead of time!

1. add a column to each of your tables of the format Date.
2. add a trigger before update or insert which sets the update/insert date
3. add a job table with startdate and enddate.
4. write a job which spools all data between the last update and sysdate. Take the sysdate one time for the whole exchange process

This might do the job.

Cheers Henning

-- 
Henning Follmann
8 Jane Road
New Providence, NJ 07974
Tel.: +1 908 464 8972
H.Follmann_at_gmx.de


-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----