Re: rollback mechanism is preventing large delete's

I don't think you could turn off the rollback mechanism as it provides an important feature of read-consistency.

There are two possible solutions:
1. create a huge rollback segment and assign the

   rollback segment to the transaction. 2. delete a batch of, say 5000 rows and do a commit.

   A good example could be found in the Oracle DBA    Handbook by Kevin Loney. I literally copied    the script without much modification.    Real handy.

Anthony

In article <7uql04$605$1_at_news.kabelfoon.nl>,   "remco" <rdoremal_at_kabelfoon.nl> wrote:
> Does anybody know how to bypass the rollback mechanism of a server?
>
> We have got a database which is slowly getting full. To prevent the
database
> from getting too full every night we perform (from a client session)
some
> "delete queries" to delete all data which is older than 6 months.
> This clean up process runs every night, however it appears it is not
> succesfull in deleting the data, because too much is deleted at once
and it
> doesn't fit in the rollback datafile anymore (or the maximum number of
> rollback segments is reached).
> What we would like to do is to switch off the rollback for those
delete
> qeuries, since we know that the data may be deleted.
> Another possibility is to swithed off the rollback mechanism of the
server
> for always, since we never use the rollback functionallity. But how?
>
> Regards
>
> remco
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 23 1999 - 01:41:00 CDT