Re: OK - Looking for the big Oracle guru brains

Scorpion 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!
>
> Dave

Put snapshot logs on the tables and use these to get the changes, unload them to file (since you haven't got db link), ship them across and apply the changes to your site.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."