Re: Question about Rollback Segments

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 14 Sep 1998 11:30:30 -0500
Message-ID: <35FD44A6.29C3D8@deere.com>

This is the difference between a 'business' transaction and a 'database' transaction.

A commit explicitly ends a database transaction.

If you want to continue to use a specified rollback segment, you must set it again after every commit.

stuco@mailcity.com wrote:

I do large loads using Pro*C programs with Embedded SQL and I COMMIT after
every 500,000 rows.

The program sets the transaction to use a large rollback segment, then INSERTs
data using bind variables.

After the first COMMIT, will my program still use the rollback segment I told
it to use, or will it randomly select another?? Remember, there are multiple
commits within the same transaction.

Thanking all of you for your valuable assistance.

Stuart L. Cowen
Paladin Consulting - Dallas

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum

  Received on Mon Sep 14 1998 - 11:30:30 CDT