Re: OK - Looking for the big Oracle guru brains

nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote in message news:<3b8cc95d.7861494_at_news>...
> On Tue, 28 Aug 2001 20:56:18 GMT, bognbac_at_yahoo.com (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?
> >
>
> Sounds like a good application for a transportable tablespace?
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam

However he wants to update just changed data and maybe the table in original database must be available all the time. I think that easy and simple solutions can be export to flat file (utility unload.sql from evergreen-database.com is very good for this task). Then import to second DB using SQL*Loader. Trigger can add copy of updated row to some special table. When all is finished, just export special table to flat file and load this file to original database. That can be working way, but it's just the guesswork, because with supplied information is really hard to find solution. It can be a good idea if author of this thread can post more detaled info. For example: Why he needs this ? and What time he has for this operation ?

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader