Re: Rollback question

Then, Is it impossible to deactivate the rollback function?

Thanks.

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.
> >
> >
> >
Received on Sun Feb 03 2002 - 08:06:37 CST