Question about Rollback Segments

From: <stuco_at_mailcity.com>
Date: Mon, 14 Sep 1998 15:38:05 GMT
Message-ID: <6tjd8t$1v0$1@nnrp1.dejanews.com>

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 - 10:38:05 CDT