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

Hi Peltier,

    Thanks for your info. Could you tell me why option 1 is better? Any concerns in using database link?

Thanks,
David

"Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message news:tXOXb.634$fE4.238_at_bignews5.bellsouth.net...
> 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 - 14:38:21 CST