Re: OK - Looking for the big Oracle guru brains
From: Henning Follmann <henning_at_odin.follmann-net>
Date: Tue, 28 Aug 2001 20:25:01 -0400
Message-ID: <slrn9oodi6.sc.henning_at_odin.follmann-net>
Date: Tue, 28 Aug 2001 20:25:01 -0400
Message-ID: <slrn9oodi6.sc.henning_at_odin.follmann-net>
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!
- add a column to each of your tables of the format Date.
- add a trigger before update or insert which sets the update/insert date
- add a job table with startdate and enddate.
- 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! ==-----Received on Wed Aug 29 2001 - 02:25:01 CEST