Re: How to force query to use a specific rollback segment in java?

barnsley97 wrote:

> Does anyone know how I can force oracle to use a specific rollback
> segment when executing a query from within my Java program?
>
> I want it to use this RBS because this is a rather long running open
> cursor that requires to save a snapshot in the RBS. This particular
> RBS will be much larger than the others and private (so that other
> trans can't get to it).
>
> I'm using the following statement in java, but it does not appear to
> be working.
>
> Statement stmt = dbConn.createStatement();
> stmt.execute(" Set transaction use rollback segment RBS_TEST ");
>
> Thanks in advace.

To mirror Chris's response ... what problem are you having? Provide the ORA-##### number and complete message text. One thing for sure is that your query is not running you out of rollback.

You can select a specific rollback segment using SET TRANSACTION but I would stronly advise you not to do it. There are plenty of problems
using this method such as what to do if that particular segment is already
used or off-line. It is far better to have all rollback segments sized large
enough to handle any transaction.

Daniel Morgan Received on Wed Jan 15 2003 - 17:22:08 CST