Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete without Rollback ? (warehouse)
In article <35CE7034.FFE359BE_at_exesolutions.com>,
EXE <exe_at_exesolutions.com> wrote:
>> You can't do that. This work style is the base to Oracle Engine.
>> You have only one exception, the "truncate" statement. With this command
>> you can
>> delete all rows from a table, but you can't choose them.
>
>I agree with this advice but would like to post a thought here that perhaps
>will be picked up by someone at Oracle. That thought is that there should be
>a way to intentionally turn off the use of rollback segments.
>
>While this is wholly inappropriate in an OLTP environment when working with
>a very large data-warehouse or data-mart where the object is to update a
>huge number of row on an all or nothing basis it is just a complete waste of
>resources to be building up a rollback segment with information that will
>never be rolled back. If the process fails the standard course of action is
>to just reload from scratch and try again.
Daniel,
Try the unrecoverable option in Create Table AS (CTAS) or direct in SQL Loader. Also, a partition view in 7.3 will allow for truncation.
mjr Received on Sun Aug 09 1998 - 23:22:16 CDT