Re: Rollback question

In article <3C5D43ED.C956D19E_at_ictnet.es>, Artur says...
>
>Then, Is it impossible to deactivate the rollback function?
>
>Thanks.
>

with the exception of a very few commands -- yes. You might believe you don't "need to rollback" but you do.

Suppose you were in the middle of a DELETE and the system failed. If we didn't have rollback for it -- you would have a corrupt database, you lose

there are some commands that will bypass undo and redo generate, like a direct path insert (insert /*+ append */ into t select ...), create table as select nologging, create index nologging, but in general, all insert/update/delete activity will generate undo.

>
>En/Na "Jaap W. van Dijk" ha escrit:
>
>> You can't.
>>
>> Rollback is not only used for rolling back but also for guaranteeing
>> that a query of another user sees the database as it is at the start
>> of the query: of all blocks that change during the runtime of the
>> query the original data is retrieved from the rollback the updating
>> processes have generated.
>>
>> Jaap.
>>
>> On Sun, 03 Feb 2002 13:16:05 +0100, Artur Undebarrena
>> <aundebarrena_at_ictnet.es> wrote:
>>
>> >Hello.
>> >
>> >I need to tell to Oracle database that do not use the rollback SQL
>> >command to accelerate the delete command. I use databases in development
>> >process and I don't need to rollback the inserts, updates and deletes. I
>> >want to accelerate my sql queries and I think if I deactivate the
>> >rollback command I'll win in speed.
>> >
>> >
>> >Thank you very much.
>> >
>> >
>> >
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp