-- Robert Hicks <[EMAIL PROTECTED]>
> Steven Lembark wrote:
>>
>> -- Robert Hicks <[EMAIL PROTECTED]>
>>
>>> I have been handed a couple of requests to change some data. One is an
>>> update on 3.6 million records and the other is two different deletions
>>> of over 16 million rows of data. I
Steven Lembark wrote:
-- Robert Hicks <[EMAIL PROTECTED]>
I have been handed a couple of requests to change some data. One is an
update on 3.6 million records and the other is two different deletions of
over 16 million rows of data. I need to be able to do these in batches as
I am told that Or
mark d wrote:
On 1/18/06, Robert Hicks <[EMAIL PROTECTED]> wrote:
mark d wrote:
On 1/18/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
mark d <[EMAIL PROTECTED]> wrote:
This optimization might have made some sense decades over a serial line, but
not today. It is saving 320 single-pack
-- Robert Hicks <[EMAIL PROTECTED]>
> I have been handed a couple of requests to change some data. One is an
> update on 3.6 million records and the other is two different deletions of
> over 16 million rows of data. I need to be able to do these in batches as
> I am told that Oracle will "blow
Andy Hassall wrote:
I have been handed a couple of requests to change some data. One is an
update on 3.6 million records and the other is two different
deletions of
over 16 million rows of data. I need to be able to do these
in batches as I
am told that Oracle will "blow up" if I do them in on
On 1/18/06, Kevin Carothers <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm not an Oracle person by ANY stretch of any imagination, but with SQL
> Server, you can insert the "new" records into a new table, drop the old
> table, and re-name the new table- thereby eliminating stuff in the rollback
> tra
Hi all,
I'm not an Oracle person by ANY stretch of any imagination, but with SQL
Server, you can insert the "new" records into a new table, drop the old
table, and re-name the new table- thereby eliminating stuff in the rollback
transaction log Dunno if this is at all possible w/ Oracle, just
> I have been handed a couple of requests to change some data. One is an
> update on 3.6 million records and the other is two different
> deletions of
> over 16 million rows of data. I need to be able to do these
> in batches as I
> am told that Oracle will "blow up" if I do them in one shot.
"
On 1/18/06, Robert Hicks <[EMAIL PROTECTED]> wrote:
> mark d wrote:
> > On 1/18/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >> mark d <[EMAIL PROTECTED]> wrote:
> >>> This optimization might have made some sense decades over a serial line,
> >>> but
> >>> not today. It is saving 320 s
mark d wrote:
On 1/18/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
mark d <[EMAIL PROTECTED]> wrote:
This optimization might have made some sense decades over a serial line, but
not today. It is saving 320 single-packet round trips, which is an
infintesimal amount of traffic.
Well, t
On 1/18/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> mark d <[EMAIL PROTECTED]> wrote:
> > This optimization might have made some sense decades over a serial line, but
> > not today. It is saving 320 single-packet round trips, which is an
> > infintesimal amount of traffic.
>
> Well, tr
mark d <[EMAIL PROTECTED]> wrote:
> This optimization might have made some sense decades over a serial line, but
> not today. It is saving 320 single-packet round trips, which is an
> infintesimal amount of traffic.
Well, traffic wise, you're right. But, it also saves parsing all those row
>>I have been handed a couple of requests to change some data. One is an
>>update on 3.6 million records and the other is two different deletions of
>>over 16 million rows of data. I need to be able to do these in batches as I
>>am told that Oracle will "blow up" if I do them in one shot.
>>
>>I wo
Robert Hicks wrote:
I have been handed a couple of requests to change some data. One is an
update on 3.6 million records and the other is two different deletions of
over 16 million rows of data. I need to be able to do these in batches as I
am told that Oracle will "blow up" if I do them in one
14 matches
Mail list logo
