Re: Extracting 2.5 million rows
From: Mladen Gogala <no_at_email.here.invalid>
Date: Thu, 7 Jan 2010 16:58:25 +0000 (UTC)
Message-ID: <pan.2010.01.07.16.58.25_at_email.here.invalid>
On Thu, 07 Jan 2010 10:37:08 +0000, Jonathan Lewis wrote:
Date: Thu, 7 Jan 2010 16:58:25 +0000 (UTC)
Message-ID: <pan.2010.01.07.16.58.25_at_email.here.invalid>
On Thu, 07 Jan 2010 10:37:08 +0000, Jonathan Lewis wrote:
> how about:
> create audit_clone nologging
> as
> select (required columns) from audit_table_at_remote ?
That's going to do wonders on the remote rollback segments.
-- http://mgogala.byethost5.comReceived on Thu Jan 07 2010 - 10:58:25 CST