Home » Other » Client Tools » Re: rollback segment
Re: rollback segment [message #38675] Mon, 06 May 2002 02:52
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Solution:
Increase rbs size or commit transaction after processing certain number of rows.Create one big rollback segement and use "SET TRANSACTION USE ROLLBACK SEGMENT xxxx" command to force oracle to use it.
Previous Topic: Calling procedures dynamically
Next Topic: SQL Loader: loading data from another server
Goto Forum:
  


Current Time: Fri Mar 29 05:43:40 CDT 2024