This content has been marked as final. Show 3 replies
I sometimes need to replicate data from one database to another. The tables are identical in structure.
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);
It depends on the speed of your network, indexes, triggers (! ) etc, but a GB of data is not much.
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