Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Newbie Question

0 views
Skip to first unread message

burgerm...@gmail.com

unread,
Dec 14, 2009, 8:45:41 PM12/14/09
to
I'm really pretty new at this, as you can probably gauge from the
sophistication of this question, but here goes anyways:

If I had two massive tables in a database, and I wanted to replace one
with the other, what would be the quickest way to do that? We're
talking millions of records here.

The first thought is to drop the records in the first table and then
iterate over each of the records in the second table, inserting each
one into the original table, finally dropping the second table
entirely.

But this is really time consuming. Surely, there must be some much
more straightforward way of doing this. A point in the right direction
is all I need. Thanks!

Frederik Engelen

unread,
Dec 15, 2009, 4:15:38 AM12/15/09
to
On Dec 15, 2:45 am, "burgermeiste...@gmail.com"

Rename table xxx to yyy ?

Otherwise, sea

Frederik Engelen

unread,
Dec 15, 2009, 4:19:37 AM12/15/09
to
On Dec 15, 2:45 am, "burgermeiste...@gmail.com"
<burgermeiste...@gmail.com> wrote:

rename table xxx to yyy?

Otherwise, google for "DB2 load from cursor". This is the fastest way
to really move your data.

--
Frederik Engelen
RealDolmen NV

0 new messages