Based on your info, I would choose option #1, but with a couple of comments:
- Do the export on server for database A to a local disk on this server.
- It would be best if the disk is fast and separate from online database
activity/files.
- Ftp the export dump file to server for database B, again to a good
performing local disk on server for database B.
- Run the import on server for database B .
- Make sure there are no indexes on the table during the import which is how
a normal import would run (creates table, inserts data, then does indexing).
- So, don't pre-create the table unless you make sure to drop indexes also
(or just not create).
--
"David" <david_at_david.nospam.com> wrote in message
news:c0o8uh$a8717_at_imsp212.netvigator.com...
> 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 - 12:37:38 CST
