Table copy via dblink

Hi.
I need to copy a 7 million table from a remote db via dblink. Wich method would you recommend, what things should I consider ?

1- create table copied_table nologging as select * from original_table_at_remote_db;

2- a. create copied_table with attribute NOLOGGING

    b. insert /*+ append */ into copied tables as select * from original_table_at_remote_db;

Local:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production NLSRTL Version 9.2.0.6.0 - Production

Remote:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

Thanks. Received on Tue Feb 14 2006 - 06:30:53 CST