What is the best way to copy 2G table data between two databases

Hi all,

    I want to copy all data from a table (which is about 2G size) from database A to B (both are 8.1.7, archive log mode, but on different server). What is the safest and fastest way to do this? I have some options:

1. exp/imp
2. insert /*+ append */ with nologging, with database link

    Which option is better? Or any other ways?

Thanks,
David Received on Sun Feb 15 2004 - 11:06:38 CST