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

David,

If you are looking for the fastest way then probably this will be the fastest..

1.Unload the data to flat file using pro*c code ( see the link for Tom Kytes code on Pro*c - I think using proc is the fastest to unload data)
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:459020243348

2.Compress the file and transfer to other server.

3.uncompress the file and use sqlldr direct mode to load data.

Thanks
Rahul. Received on Sun Feb 15 2004 - 22:19:41 CST