Hi,

For Oracle 8.1.7 - don't know about Oracle 9

You can't exactly set the rollback segment to a user. However you could:
1. turn all the other rollback segments offline
2. have user run job.
3. turn on the other rollback segments
the above is not helpful during a normal work period, it also assumes that
you have one very large rollback segment to use.

Another way:
the user could use the set transaction command inside the sql
the above only works until it encounters a commit and then the set
transaction must be set again.

Another way:
as sys use the Oracle supplied delete_commit procedure and keep the number
of records to delete small so you don't run out of rollback segments. I
used this method to delete 200,000 in about 5 min.

I hope one of these ways helps a bit.

J




Oracle LazyDBA home page