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.

Report message to a moderator

Previous Topic: Calling procedures dynamically
Next Topic: SQL Loader: loading data from another server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Oct 03 03:20:48 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.