It is by far the fastest way to get data from one system to another.
truncate local_table; insert into local_table (select * from identical_remote_table@database_link);
1000983 wrote:Are you copying entire tables? If so, you might consider a transportable tablespace.
1. Need to transfer about a GB of data from one Oracle database system to another on a daily basis. Does anyone see a problem with fetching that much of data using database link? If this is not a good option, what are my other options. We tried spooling the data and loading. That takes hours to complete