Transfer large partitioned table using dblink
Hi,
Please tell me the fastest way to transfer single partition of very large partitioned table on second database, using dblink.
I need to transfer partition (about 100GB) using dblink.
What are my options:
- insert into local_table select * from table(partition)@database_link;
- insert /*+ APPEND */ into local_table select * from table(partition)@database_link;
Thanks.