copying large data on production environment
From: mick.w <mick.w_at_poczta.fm>
Date: Tue, 28 Sep 2010 06:55:32 -0700 (PDT)
Message-ID: <5be70ced-5d00-442d-b583-da4ad4cd17fe_at_m15g2000yqm.googlegroups.com>
I need to copy large data from one table to another (insert into.. values (select * from ...)) on production environment (system must be running). I can do this in few parts, copying data partition by partition. Are there any hint for this problem to avoid slowdown of system? Received on Tue Sep 28 2010 - 08:55:32 CDT
Date: Tue, 28 Sep 2010 06:55:32 -0700 (PDT)
Message-ID: <5be70ced-5d00-442d-b583-da4ad4cd17fe_at_m15g2000yqm.googlegroups.com>
I need to copy large data from one table to another (insert into.. values (select * from ...)) on production environment (system must be running). I can do this in few parts, copying data partition by partition. Are there any hint for this problem to avoid slowdown of system? Received on Tue Sep 28 2010 - 08:55:32 CDT